Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Wednesday, December 15, 2010

Dropping a Database

SQL> shutdown abort;
ORACLE instance shut down.

SQL> startup mount exclusive restrict pfile=D:\FRATEST\FRADB\pfile\initFRADB.ora
ORACLE instance started.


Total System Global Area 1073741824 bytes
Fixed Size                  1253124 bytes
Variable Size             264241404 bytes
Database Buffers          801112064 bytes
Redo Buffers                7135232 bytes
Database mounted.


SQL> drop database;

Database dropped.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options


SQL> exit

C:\Documents and Settings\inam>

No comments: