Problem with Droping user table called DUAL
From: Vijay Raghavan <raghavav_at_cs.rpi.edu>
Date: Thu, 28 May 1992 16:04:30 GMT
Message-ID: <8k-wl+f_at_rpi.edu>
Date: Thu, 28 May 1992 16:04:30 GMT
Message-ID: <8k-wl+f_at_rpi.edu>
I am not able to drop a table I created called 'DUAL'. It gives the following error.
SQL> drop table vijay.dual;
ORA-00056: DDL lock on object '910' is already held in an incompatible mode
Is there any clash with the system table called 'DUAL'? I have this problem even after restarting the database, therefore releasing all the parse locks.
-- =============================================================================== Vijay Raghavan | We can sort things out together. ROSE group, Dept of Comp Sc | Rensselaer Polytechnic Institute | Ph:(518)-276-4838Received on Thu May 28 1992 - 18:04:30 CEST