| Regarding DROP TABLE... [message #68377] |
Thu, 03 July 2003 00:40 |
K N Venkateswarlu
Messages: 2
Registered: July 2003
|
Junior Member |
|
|
Hi Right now Im using Oracle9i. 20days back I have created a table "TEST_LT" by using "Enterprise Management Console". Ofcourse this is only for test purpose i have created this table by using this GUI. So when I have created this table automatically by default It have created 12 VIEWS. The View Names are,
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
TEST VIEW
TEST_BASE VIEW
TEST_BPKC VIEW
TEST_CONF VIEW
TEST_DIF1 VIEW
TEST_DIF2 VIEW
TEST_DIFF VIEW
TEST_LOCK VIEW
TEST_LT TABLE
TEST_MW VIEW
TEST_MWB VIEW
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
TEST_PKC VIEW
TEST_PKD VIEW
Now Im trying to dropping this TABLE by using DROP Statement.
But Its giving the following Errors.
SQL> DROP USER test CASCADE;
DROP USER test CASCADE
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-20031: All version enabled tables owned by 'TEST' must be disabled first.
ORA-06512: at "SYS.WM_ERROR", line 218
ORA-06512: at "SYS.WM_ERROR", line 235
ORA-06512: at "SYS.NO_VM_DROP_PROC", line 40
ORA-06512: at line 3
So, pls help me out how to DROP this table. Is there any changes I have to make?
Thanx in Advance.
Regards
Venkat.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
