#> sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.3.0 Production on Thu Mar 8 23:22:42 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup restrict mount;
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2228784 bytes
Variable Size 402656720 bytes
Database Buffers 1191182336 bytes
Redo Buffers 7344128 bytes
Database mounted.
SQL> drop database;
Database dropped.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
how to drop a database..using dbca command...in otherwords i want to delete a database by selecting the option (delete database) in dbca list of option..when i try to delete a database using this option i am getting ora-01031-Insufficient privileges...
ReplyDeleteWith which user you have logged into the server? User must be same as software owner.
ReplyDelete