-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博客

manual database deletion for oracle10g on solaris10

最新文章