problem in dropping a database [message #319785] |
Tue, 13 May 2008 00:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
mbhavin
Messages: 32 Registered: May 2008 Location: INDIA
|
Member |
![+](/forum/theme/orafaq/images/yahoo.png)
|
|
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 #319841 is a reply to message #319837] |
Tue, 13 May 2008 03:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|