Tag: 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.
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
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
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
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.
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.
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