OraFAQ Forum: Server Administration » drop oracle8 database

Home » RDBMS Server » Server Administration » drop oracle8 database (solaris10)

Tue, 08 July 2008 00:01

dirish
Messages: 232
Registered: November 2006

Senior Member

How can I drop an oracle8 database?

Thank you,
Dirish

Tue, 08 July 2008 00:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

rf -rf /

Tue, 08 July 2008 00:13

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

Tue, 08 July 2008 01:07

Michel Cadot
Messages: 68672
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

"drop database" does not exist.
Remove all the database files at OS level.

Regards
Michel

Tue, 08 July 2008 01:49

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

Tue, 08 July 2008 02:14

Michel Cadot
Messages: 68672
Registered: March 2007
Location: Nanterre, France, http://...

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: Wed Aug 07 10:48:02 CDT 2024