Dropping Database

SQL> drop database ;
drop database
*
ERROR at line 1:
ORA-01507: database not mounted

SQL> @C:\oracle\product\10.2.0\admin\jdb2\udump\ctrl.sql

Control file created.

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01100: database already mounted

SQL> drop database;
drop database
*
ERROR at line 1:
ORA-12719: operation requires database is in RESTRICTED mode

SQL> alter database enable restricted mode;
alter database enable restricted mode
*
ERROR at line 1:
ORA-00933: SQL command not properly ended

SQL> alter system enable restricted session;

System altered.

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>

OCP DBA from 9i to 11g

I was just looking for the upgrading myself from 9i OCP DBA to 11g. but could not find any details or examination that could be done due to recent examinations released from Oracle. But I spoke to Oracle Support and they figure out that yes exam does exists for the same.

So I thought of sharing for the aspiring OCP 9i DBA aspiring to be OCP 11g DBA's

Here is the details.

Oracle Database 11g: New Features for Administrators

1Z0-055 Oracle Database 11g: New Features for 9i OCPs

Oracle Database 11g DBA OCP

I hope this post will be helpful to most of the aspiring DBA's.

Any feedback are welcome.