I have created a test Oracle 8.1.6 database on Sun Solaris 7. How can I completely drop the database to create a new production database afresh?
Printable View
I have created a test Oracle 8.1.6 database on Sun Solaris 7. How can I completely drop the database to create a new production database afresh?
If you have the database assistant, you can do it graphically. Or else stop the databae and remove all files related to the database.
uday
If you are not going to use the dbassist, then make sure that you make the changes in the orainstall/orainvetory files or if database is the only installation that you have then just remove the orainstall/orainventory, the reason is that when you do the installation next time, installer would look into the inventory and decide that you have already installed the database.
Good luck
Sam
Even if you use "dbassist" still you need to do some clean up of OFA file structures/folders and oratab entry etc.,
I meant total clean up of the database. Even if you don't not gonna hurt anything on the box.