Skip to content

{ Tag Archives } new oracle dba

Permissions for Oracle binaries and files – reference article for the new Oracle DBA

new oracle dba can find out all about the permissions assigned to oracle binaries and files.

Also tagged ,

what is oracle NLS_LANG parameter? – complete reference for the new oracle dba

what is oracle NLS_LANG parameter? – complete reference for the new oracle dba

Also tagged , , ,

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

Also tagged , ,

How to enable hot backups – complete reference for the new oracle dba

make hot backups or backups while the database is up and running – learn how – for the new oracle dba

Also tagged , ,

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

Also tagged ,

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.

Also tagged , ,

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.

Also tagged , , , ,

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.

Also tagged , , ,

using exception handling in pl/sql – the new oracle dba reference

The new oracle dba can fine here an example of using exception handling in pl/sql blocks.

Also tagged , ,

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

Also tagged , ,