Home » RDBMS Server » Enterprise Manager » Regarding DROP TABLE...
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.
Previous Topic: Reg. Integrity checks
Next Topic: How to start the Agent on Server with OMS
Goto Forum:
  


Current Time: Mon May 23 00:54:05 CDT 2022