Pages

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:

Post a Comment