Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do I drop a 9i database

481897May 1 2008 — edited May 1 2008
nut% sqlplus

SQL*Plus: Release 9.2.0.5.0 - Production on Thu May 1 12:17:57 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: /as sysdba
Connected to an idle instance.


SQL> startup mount exclusive restrict
ORACLE instance started.

Total System Global Area 403789196 bytes
Fixed Size 456076 bytes
Variable Size 369098752 bytes
Database Buffers 33554432 bytes
Redo Buffers 679936 bytes
Database mounted.
SQL> drop database;
drop database
*
ERROR at line 1:
ORA-02026: missing LINK keyword


SQL> drop database LINK
2 ;

*
ERROR at line 2:
ORA-01729: database link name expected


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

What's the procedure of dropping a 9i database?
What's the statement of dropping a database?

Thanks a lot!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 29 2008
Added on May 1 2008
5 comments
4,727 views