Friday 9 April 2010

Oracle Drop database

To drop a database I did the following :

SQL> shutdown abort;
startup mount exclusive restrict;
ORACLE instance shut down.
SQL> ORACLE instance started.

Total System Global Area 630501376 bytes
Fixed Size 2147032 bytes
Variable Size 469765416 bytes
Database Buffers 150994944 bytes
Redo Buffers 7593984 bytes
Database mounted.
SQL> connect as sysdba
Enter password:
Connected.
SQL> drop database;

No comments:

Post a Comment

Word Press Multisite on AWS instance cannot login with default password

  Word Press Multisite on AWS instance cannot login with default password after setting a static IP ? Try this Login to the shell from AWS i...