Home » RDBMS Server » Server Administration » Effficeint Way of droping the database
Effficeint Way of droping the database [message #50994] Thu, 18 April 2002 20:13 Go to next message
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 Go to previous message
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.
Previous Topic: networked oracle home placed on db server?
Next Topic: How to move old DB data to newly modified DB?
Goto Forum:
  


Current Time: Mon Sep 09 18:59:13 CDT 2024