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

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: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use DBCA. does a pretty clean job.
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??
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
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: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't wake the zombie.

Regards
Michel
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.
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
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: 64102
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

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.
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?
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: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
It's a super zombie

Anyone got a zombie smiley?
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: 4640
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.
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: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Maybe real zombies do smile.


Ouaaarff! ./fa/449/0/


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:

./fa/7106/0/
  • Attachment: zombie.gif
    (Size: 12.08KB, Downloaded 4147 times)
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:
  


Current Time: Fri Dec 02 16:32:49 CST 2016

Total time taken to generate the page: 0.27782 seconds