Home » RDBMS Server » Server Administration » drop oracle8 database (solaris10)
drop oracle8 database [message #332231] Tue, 08 July 2008 00:01 Go to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
How can I drop an oracle8 database?


Thank you,
Dirish
Re: drop oracle8 database [message #332232 is a reply to message #332231] Tue, 08 July 2008 00:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
rf -rf /
Re: drop oracle8 database [message #332235 is a reply to message #332232] Tue, 08 July 2008 00:13 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
i didn't get you!

in sql>
drop database (db-name) including datafiles;


Then I should manually delete the files from OS.

Please confirm if am doing it the right way.


Thank you,
Dirish
Re: drop oracle8 database [message #332263 is a reply to message #332235] Tue, 08 July 2008 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
"drop database" does not exist.
Remove all the database files at OS level.

Regards
Michel
Re: drop oracle8 database [message #332283 is a reply to message #332263] Tue, 08 July 2008 01:49 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
so u mean that I should only remove dbf, ctrl, etc at OS level.

there is no such sql to delete the database
Re: drop oracle8 database [message #332291 is a reply to message #332283] Tue, 08 July 2008 02:14 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Not in 8.
Yes, you just have to rm the files and remove its entry in oratab if you added it.
You can use dbca to do this.

Regards
Michel
Previous Topic: BreakUnbreak Oracle Jobs
Next Topic: Oracle 9i Developer Problem
Goto Forum:
  


Current Time: Sun Dec 01 21:46:07 CST 2024