| Dropping a user/Tablespace [message #15637] |
Sun, 17 October 2004 23:40 |
Suman Dasgupta
Messages: 22
Registered: August 2004
|
Junior Member |
|
|
I have a user SDA/SDA that is connected with the default tablespace SDA. Now I want to drop the user and the tablespace. The following queries give me the following errors...
SQL> DROP TABLESPACE SDA INCLUDING CONTENTS;
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
The same thing happens with the user:
SQL> DROP USER SDA CASCADE;
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
How do I solve it.. Please help...
Regards...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
