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 ,
2011 09 19 x_sridhar faq's-common doubts Comments (0)

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 , , ,
2011 02 21 x_sridhar interesting advanced dba articles Comments (0)

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 , ,
2011 02 14 x_sridhar real life scenarios Comments (0)

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 , ,
2011 02 11 x_sridhar faq's-common doubts Comments (0)

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 ,
2011 02 10 x_sridhar faq's-common doubts Comments (0)

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 , ,
2011 02 09 x_sridhar interesting advanced dba articles Comments (0)

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 , , , ,
2011 02 09 x_sridhar interesting advanced dba articles Comments (0)

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 , , ,
2011 02 08 x_sridhar sql and plsql Comments (0)

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 , ,
2011 02 08 x_sridhar sql and plsql Comments (0)

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 , ,
2011 02 08 x_sridhar interesting advanced dba articles Comments (0)