Home » RDBMS Server » Server Administration » drop the database
drop the database [message #140637] Wed, 05 October 2005 00:58 Go to next message
kinjal
Messages: 124
Registered: June 2001
Senior Member
Hello,

I want to drop whole database of oracle9i..

Which is the best way to do it?

Please help me. Its urgent.

Thanks,
Kinjal

Report message to a moderator

Re: drop the database [message #140638 is a reply to message #140637] Wed, 05 October 2005 01:08 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

You can use Oracle's Database Configuration Assistant.

Report message to a moderator

Re: drop the database [message #140640 is a reply to message #140637] Wed, 05 October 2005 01:09 Go to previous messageGo to next message
kinjal
Messages: 124
Registered: June 2001
Senior Member
Hi Tarun,

Thanks.. I think thats the only method to drop the database...

thanks again,

Kinjal

Report message to a moderator

Re: drop the database [message #140641 is a reply to message #140640] Wed, 05 October 2005 01:14 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Quote:

.. I think thats the only method to drop the database


No its not the only method i suppose. You can drop it manually also but you need to follow steps :

--> Delete the service using ORADIM utility.

--> Delete the pfile,spfile,password file , log files, database files, control files .

--> clean up the tnsnames.ora and listener.ora if there are entries for the database.

and after doing all this i think database is deleted from the system .

If others think that anything else is required then please let me know.

regards,
tarun

Report message to a moderator

Re: drop the database [message #140643 is a reply to message #140637] Wed, 05 October 2005 01:16 Go to previous messageGo to next message
kinjal
Messages: 124
Registered: June 2001
Senior Member
Hello Tarun,

Actually I did a writing mistake..
I mean its the only easy method to drop the database..

If do it manually, is somewhat complex I can say..

Thanks for support,
Kinjal

Report message to a moderator

Re: drop the database [message #140644 is a reply to message #140643] Wed, 05 October 2005 01:18 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Hi kinjal,

Very correct , i just wanted to discuss. Manual will take a lot of time. Razz


cheers,
tarun

Report message to a moderator

Re: drop the database [message #140659 is a reply to message #140644] Wed, 05 October 2005 02:11 Go to previous messageGo to next message
kinjal
Messages: 124
Registered: June 2001
Senior Member
Hi,

I dropped my database using dbca.

Then I deleted all my datafiles, control files and logfiles also.

Any other thing which I need to take care of?

Thanks,
Kinjal

Report message to a moderator

Re: drop the database [message #140662 is a reply to message #140644] Wed, 05 October 2005 02:28 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

Its easy to drop database with DBCA but its better to know how to drop database manually ... and that is only posible if you have clear concept of oracle database architecture Smile in your brain.... i can bet... it will be intresting experience for u to drop db (i.e. database) manually... try it out.

Note:- Try such thing on your home pc not with live database Very Happy

Regards
Always friend sunilkumar.

[Updated on: Wed, 05 October 2005 02:29]

Report message to a moderator

Previous Topic: how to read a control file structure
Next Topic: cannot start Oracle instance
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 10:24:57 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.