Home » RDBMS Server » Server Administration » problem in dropping a database
problem in dropping a database [message #319785] Tue, 13 May 2008 00:58 Go to next message
mbhavin
Messages: 32
Registered: May 2008
Location: INDIA
Member

when i tried to drop my database i got this error

i tried to start my database in mount mode

using


SQL> startup mount
ORACLE instance started.

Total System Global Area 1157174532 bytes
Fixed Size 451844 bytes
Variable Size 369098752 bytes
Database Buffers 786432000 bytes
Redo Buffers 1191936 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode


now when i issue a drop command as follow i got the error message like

SQL> drop database AUX
2 ;
drop database AUX
*
ERROR at line 1:
ORA-02026: missing LINK keyword

please help me out
Re: problem in dropping a database [message #319801 is a reply to message #319785] Tue, 13 May 2008 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68676
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your Oracle version (4 decimals)?

Regards
Michel
Re: problem in dropping a database [message #319814 is a reply to message #319801] Tue, 13 May 2008 02:01 Go to previous messageGo to next message
mbhavin
Messages: 32
Registered: May 2008
Location: INDIA
Member

my oracle version is 9.2.0.4.0
Re: problem in dropping a database [message #319826 is a reply to message #319814] Tue, 13 May 2008 02:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68676
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"drop database" statement was introduced in 10g.

Regards
Michel
Re: problem in dropping a database [message #319832 is a reply to message #319826] Tue, 13 May 2008 02:42 Go to previous messageGo to next message
mbhavin
Messages: 32
Registered: May 2008
Location: INDIA
Member

how to drop database in oracle 9i
Re: problem in dropping a database [message #319836 is a reply to message #319832] Tue, 13 May 2008 02:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68676
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Drop all the files at OS level.

Regards
Michel
Re: problem in dropping a database [message #319837 is a reply to message #319785] Tue, 13 May 2008 02:52 Go to previous messageGo to next message
mbhavin
Messages: 32
Registered: May 2008
Location: INDIA
Member

means
rm /newdata/oracle/oradata/CATDB/system01.dbf
Re: problem in dropping a database [message #319841 is a reply to message #319837] Tue, 13 May 2008 03:08 Go to previous message
Michel Cadot
Messages: 68676
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, and all other ones including redo logs, control files, spfile, init.ora, trace files, archived logs... if you want to remove all. (Note that drop database only drop data files, temp files, redo logs, control files and spfile but not init.ora, archived logs and trace files).

Regards
Michel
Previous Topic: partition error
Next Topic: Privilege problem in Oracle to make it more secure
Goto Forum:
  


Current Time: Mon Sep 09 18:10:29 CDT 2024