Effficeint Way of droping the database [message #50994] |
Thu, 18 April 2002 20:13 |
Milind S Deobhankar
Messages: 33 Registered: January 2002
|
Member |
|
|
I had one database which was created during the installation, but now i want to drop the database and create the new with the help of the script so can any body tell me how to drop the existing database efficiently
|
|
|
Re: Effficeint Way of droping the database [message #50995 is a reply to message #50994] |
Thu, 18 April 2002 21:14 |
seng
Messages: 191 Registered: February 2002
|
Senior Member |
|
|
two steps to drop a database.
NT/Win2000
1. shutdown database.
2. remove datafile,redo log,control file, paramter and other files.
3. remove Oracle services using ORADIM
4. Clear the environment setting.
Unix
1. shutdown database.
2. remove datafile,redo log,control file, paramter and other files.
3. No need to drop Oracle Services
4. Clear the environemnt setting
Hope this is helping
or Using Oracle Assitance to create database.
|
|
|