It has become easier to drop a database from Oracle 10g. Use the DROP DATABASE command to drop the database. It removes the datafiles, redologs, controlfiles and init parameter files.
$ sqlplus / as sysdba
SQL> Shutdown immediate;
SQL> Startup Mount Exclusive Restrict;
SQL> Drop Database;
Thanks
Saturday, July 17, 2010
Subscribe to:
Post Comments (Atom)
3 comments:
Thanks for sharing info.
Pooja
MLM Developers India
http://mlmdevelopers.com/products/mlm-software/corporate-mlm-soft/feature.html
thanks for such a nice post
Anukant
MLM software India
http://www.max3logic.com
Thanks for sharing this query to get the details of database like name, id, creation time and its version. I have also other queries too that you have posted in other articles, I will implement this one also. Keep posting more in future also.
sap migration
Post a Comment