Oracle Database Discussions

Hi Everyone,

I mistakenly ran a schema drop script against my oracle instance and managed to drop a series of tables that I didn't intend to. At this point the instance has stopped accepting connections and I'm trying to find the best way to restore or reset it. The data that is in the database is disposable test data but I would like to somehow salvage instance itself. Unfortunately I'm not familiar enough with Oracle to know exactly what the tables did that were dropped or how I can recreate these. I included the output from the drop script below (the portion that printed out to my terminal before I managed to kill it off). Thanks for your help!

SQL>
SQL> -- dropping All objects in a schema....
SQL>
SQL> -- dropping table
SQL>
SQL> drop table TYPE_MISC$ cascade constraints;

Table dropped.

SQL> drop table ATTRCOL$ cascade constraints;

Table dropped.

SQL> drop table ASSEMBLY$ cascade constraints;

Table dropped.

SQL> drop table LIBRARY$ cascade constraints;

Table dropped.

SQL> drop table VIEWTRCOL$ cascade constraints;

Table dropped.

SQL> drop table ICOLDEP$ cascade constraints;

Table dropped.

SQL> drop table OPQTYPE$ cascade constraints;
drop table OPQTYPE$ cascade constraints
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist


SQL> drop table REFCON$ cascade constraints;
drop table REFCON$ cascade constraints
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist


SQL> drop table NTAB$ cascade constraints;
drop table NTAB$ cascade constraints
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist


SQL> drop table SUBCOLTYPE$ cascade constraints;
drop table SUBCOLTYPE$ cascade constraints
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist


SQL> drop table COLTYPE$ cascade constraints;
drop table COLTYPE$ cascade constraints
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist


SQL> drop table LOB$ cascade constraints;
drop table LOB$ cascade constraints
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist


SQL> drop table TAB$ cascade constraints;
drop table TAB$ cascade constraints
*
ERROR at line 1:
ORA-00701: object necessary for warmstarting database cannot be altered


SQL> drop table CLU$ cascade constraints;
drop table CLU$ cascade constraints
*
ERROR at line 1:
ORA-00701: object necessary for warmstarting database cannot be altered


SQL> drop table COL$ cascade constraints;
drop table COL$ cascade constraints
*
ERROR at line 1:
ORA-01013: user requested cancel of current operation