OraFAQ Forum: SQL & PL/SQL » Deleting a database???

Home » SQL & PL/SQL » SQL & PL/SQL » Deleting a database???

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Deleting a database??? [message #386]

Fri, 08 February 2002 11:40

Rami
Messages: 7
Registered: February 2002

Junior Member

How do i delete a database????
thanks

Report message to a moderator

Re: Deleting a database??? [message #388 is a reply to message #386]

Fri, 08 February 2002 13:36

sokeh
Messages: 77
Registered: August 2000

Member

use database configuration assistant. it is easier

Report message to a moderator

Re: Deleting a database??? [message #390 is a reply to message #386]

Fri, 08 February 2002 13:38

sokeh
Messages: 77
Registered: August 2000

Member

use database configuration assistant. it is easier

Report message to a moderator

Re: Deleting a database??? [message #401 is a reply to message #386]

Sun, 10 February 2002 18:40

nash
Messages: 10
Registered: February 2002

Junior Member

TRY this at SQL prompt :

drop database <database_name>;

HTH

nash

Report message to a moderator

Re: Deleting a database??? [message #513 is a reply to message #386]

Sun, 17 February 2002 16:39

seng
Messages: 191
Registered: February 2002

Senior Member

You can drop database manually or Database Configuration Assistant. Database Configuration Assistant is a easy way.

****Database Configuration Assistant
- all processes is done by Assistant

****Manually method.
UNIX
- shutdown database first
- delete control file, redo log file, data file and parameter file.
- remove enviroment setting e.g ORACLE_SID.

NT/WINDOW 2000
- shutdown the database first.
- stop and delete oracle service from control panel(only NT/WINDOS200 has created service for Oracle}.
- delete control file, redo log file, data file,password file and parameter file.
- remove enviroment setting e.g ORACLE_SID.

I hope this is working. Thanks

Report message to a moderator

Previous Topic:	forms 6 install
Next Topic:	Trigger works But !!!!!!!!!!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 12:07:31 CDT 2024