Oracle DBA by Teshome Asfaw

Uwe Hesse in his article Dropping a table during SELECT has described how dropping a table during select statement works in oracle database...

A very good documentation on designing and implementing mission critical database. I found it quiet interesting though now far from what I n...

Adaption of SOA is more likely to succeed if you embark a good but simple SOA governance. The following white paper explains the approches a...

I was looking for ways of displaying table names and number of rows it hold. It took me a lot of time to figure out how this can be done. Af...

steps 1. create dump directory (CREATE DIRECTORY metadata_export AS '/opt/app/oracle'; 2. make sure the directory has got read and w...