Home » RDBMS Server » Server Administration » drop database in oracle 10g
drop database in oracle 10g [message #185586] Wed, 02 August 2006 08:13 Go to next message
sureshht_ny
Messages: 3
Registered: August 2006
Location: Albany
Junior Member
Hi,
How do i drop database in oracle 10G?
Have anyone used 'DROP DATABASE' command for dropping database in oracle 10G?
Thanks and regards
Suresh H Thopaiah

Report message to a moderator

Re: drop database in oracle 10g [message #185588 is a reply to message #185586] Wed, 02 August 2006 08:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use DBCA. does a pretty clean job.

Report message to a moderator

Re: drop database in oracle 10g [message #185620 is a reply to message #185586] Wed, 02 August 2006 13:03 Go to previous messageGo to next message
sureshht_ny
Messages: 3
Registered: August 2006
Location: Albany
Junior Member
No..I want to use drop command only...anyone has done it??

Report message to a moderator

Re: drop database in oracle 10g [message #316884 is a reply to message #185620] Mon, 28 April 2008 13:32 Go to previous messageGo to next message
awadhesh999
Messages: 1
Registered: October 2007
Junior Member
Hi,


For dropping a database from command line in 10. please follow these steps:-

Connect as sysdba user

sqlplus / as sysdba
shutdown immediate
startup mount exclusive restrict;
drop database;
exit

Report message to a moderator

Re: drop database in oracle 10g [message #316885 is a reply to message #316884] Mon, 28 April 2008 14:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't wake the zombie.

Regards
Michel

Report message to a moderator

Re: drop database in oracle 10g [message #317875 is a reply to message #185620] Sun, 04 May 2008 09:33 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Dropping a Database
Dropping a database involves removing its datafiles, redo log files, control files, and initialization parameter files. The DROP DATABASE statement deletes all control files and all other database files listed in the control file. To use the DROP DATABASE statement successfully, all of the following conditions must apply:

The database must be mounted and closed.

The database must be mounted exclusively--not in shared mode.

The database must be mounted as RESTRICTED.

An example of this statement is:

DROP DATABASE;

The DROP DATABASE statement has no effect on archived log files, nor does it have any effect on copies or backups of the database. It is best to use RMAN to delete such files. If the database is on raw disks, the actual raw disk special files are not deleted.

If you used the Database Configuration Assistant to create your database, you can use that tool to delete (drop) your database and remove the files.

Report message to a moderator

Re: drop database in oracle 10g [message #431445 is a reply to message #317875] Tue, 17 November 2009 06:30 Go to previous messageGo to next message
samg4ug
Messages: 33
Registered: July 2007
Location: India
Member
Hi,

If you are dropping the database in Unix make sure that the database 's entry is commented out in /etc/oratab file.

Else you won't be able to create a same named database in the server. While creating it will throw error that database already exists.

Regards,
Sam G

Report message to a moderator

Re: drop database in oracle 10g [message #431448 is a reply to message #431445] Tue, 17 November 2009 06:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Mon, 28 April 2008 21:06
Don't wake the zombie.

Regards
Michel

Report message to a moderator

Re: drop database in oracle 10g [message #433646 is a reply to message #185586] Thu, 03 December 2009 08:03 Go to previous messageGo to next message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
Well I guess the proper way to do it is the command DROP DATABASE (honestly, I did not know about this command in 10, now I do).

So far in my life as DBA and various UNIX flavours (AIX, SunOS and HP), I have done the following:

1. shutdowm immediate
2. rm -Rf /u0[1-4]/oradata/ORACLE_SID
3. update oratab, listener.ora, tnsnames.ora
4. be happy and reclaim your space...

Thanx.

Report message to a moderator

Re: drop database in oracle 10g [message #433823 is a reply to message #433646] Fri, 04 December 2009 07:31 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Will this thread NEVER die?

Report message to a moderator

Re: drop database in oracle 10g [message #433831 is a reply to message #433823] Fri, 04 December 2009 07:57 Go to previous messageGo to next message
cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester
Senior Member
It's a super zombie

Anyone got a zombie smiley?

Report message to a moderator

Re: drop database in oracle 10g [message #433835 is a reply to message #433831] Fri, 04 December 2009 08:04 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
In all movies I have ever seen, I have never seen a zombie smile, but that's just in movies. Maybe real zombies do smile.

Report message to a moderator

Re: drop database in oracle 10g [message #433840 is a reply to message #433835] Fri, 04 December 2009 08:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Maybe real zombies do smile.


Ouaaarff! /forum/fa/449/0/


Report message to a moderator

Re: drop database in oracle 10g [message #433851 is a reply to message #433835] Fri, 04 December 2009 09:40 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Kill the zombie:

/forum/fa/7106/0/
  • Attachment: zombie.gif
    (Size: 12.08KB, Downloaded 5268 times)

Report message to a moderator

Re: drop database in oracle 10g [message #434073 is a reply to message #433851] Mon, 07 December 2009 02:09 Go to previous message
samg4ug
Messages: 33
Registered: July 2007
Location: India
Member
Hi,

Ok to stop the thread.
But is knowing how to drop database without using dbca is so bad as to gather knowledge ?
Atleaset a DBA who has some spare dbs to play with can try it...

If dba s learn about it then what's the offence ?

Regards,
Sam G

[Updated on: Mon, 07 December 2009 02:10]

Report message to a moderator

Previous Topic: Recommended tools For Monitoring Oracle Databases
Next Topic: reduce the size of the table file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 01:19:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.