Tag: oracle dba career
Real life usage of Oracle Import and export scenarios – complete reference for the new DBA
Real life usage of Oracle Import and export scenarios – complete reference for the new DBA
why do we create self referential foreign keys – knowledge article for the new oracle dba
why do we create self referential foreign keys – knowledge article for the new oracle dba
How do oracle external jobs work – reference for the new oracle dba
Below article contains a discussion on oracle external jobs and what should be done to fix problems with oracle external jobs.
estimating table,index,temp,rollback,undo space usage – reference for the new oracle dba
Below article can explain in detail on how to estimate the space required for a table , index , temporary tablespace , rollback segment , redo log files.
using execute immediate in pl/sql – the new oracle dba reference
If you are a new oracle dba and you want to know how to use the execute immediate command , then you have the complete reference in below article.
bug report-ddl on an object invalidates dependent synonyms until oracle 10.2.0.5
bug report-ddl on an object invalidates dependent synonyms until oracle 10.2.0.5
what are distributed transactions? – complete reference for the new oracle dba
what are distributed transactions? – complete reference for the new oracle dba
distributed transactions troubleshooting – complete reference for the new oracle dba
distributed transactions troubleshooting – complete reference for the new oracle dba
Using display and xwindows – useful reference for the new oracle dba
Using display and xwindows – useful reference for the new oracle dba
dbms_sql examples – complete reference for the new oracle dba
dbms_sql examples – complete reference for the new oracle dba