Drop a database

There are times when you require to drop your existing database for more than one reason.  Dropping a database is not a tough job at all, if you are very sure that which database you should drop. Originally written for Oracle 11g. The DROP DATABASE command syntax and prerequisites remain the same in Oracle 12c, Read more about Drop a database[…]

Oracle Data Pump evolution timeline from legacy exp/imp utility in 9i through modern Data Pump in Oracle 19c

Data Pump: a tool to backup and restore database

Among various techniques of backing up your database Oracle provides data pump as one of tool which they are constantly improving and making this tool sharper release by release. Data Pump was introduced in Oracle 10g as a replacement for exp/imp. This post covers the concepts that remain valid through Oracle 19c and 21c. For Read more about Data Pump: a tool to backup and restore database[…]