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