manual database deletion for oracle10g on solaris10

wisdomone1發表於2010-01-19
DatabaseOracle
-bash-3.00$ export ORACLE_SID=manualdb
-bash-3.00$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Dec 15 10:09:56 2009

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Connected to an idle instance.

             mount exclusive
ORACLE instance started.

Total System Global Area  100663296 bytes
Fixed Size                  1278688 bytes
Variable Size              88083744 bytes
Database Buffers            8388608 bytes
Redo Buffers                2912256 bytes
Database mounted.
SQL> drop database;
drop database
*
ERROR at line 1:
ORA-12719: operation requires database is in RESTRICTED mode


SQL> alter system enable restricted session;

System altered.

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> exit
-bash-3.00$ ps -ef|grep ora_
  oracle  1064  1031   0 10:11:28 pts/5       0:00 grep ora_
-bash-3.00$ ps -ef|grep oracle
  oracle  1066  1031   0 10:11:30 pts/5       0:00 grep oracle
  oracle  1031  1028   0 10:09:14 pts/5       0:00 -bash
  oracle  1065  1031   0 10:11:30 pts/5       0:00 ps -ef
-bash-3.00$ pwd
/export/home/orainstall
-bash-3.00$ ls
10202_database_solx86.zip  Desktop                    Documents                  database                   oraInventory               oracle

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9240380/viewspace-625461/，如需轉載，請註明出處，否則將追究法律責任。

相關文章