Re: Can't drop a table, even as sysdba

From: Tim Gorman <tim_at_evdbt.com>
Date: Thu, 02 Aug 2012 07:46:52 -0600
Message-ID: <501A84CC.4070709_at_evdbt.com>

SQL trace the session running this test, find the line in the resulting trace file which includes the phrase "err=-942", associate that line back to the cursor's SQL statement, and then open an SR... :-)

On 8/2/2012 7:39 AM, Thomas Day wrote:
> SQL> SHO USER
> USER is "SYS"
> SQL> CREATE TABLE JUNK (JUNQUE NUMBER);
> Table created.
>
> SQL> DROP TABLE JUNK PURGE;
> DROP TABLE JUNK PURGE
> *
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00942: table or view does not exist
> ORA-06512: at line 19
>
>
> SQL> DESC SYS.JUNK
> Name Null? Type
> ----------------------------------------- --------
> ---------------------------
> JUNQUE NUMBER
>
> SQL> select * from v$version;
> BANNER
> --------------------------------------------------------------------------------
> Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
> PL/SQL Release 11.2.0.3.0 - Production
> CORE 11.2.0.3.0 Production
> TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
> NLSRTL Version 11.2.0.3.0 - Production
> Any ideas would be greatly appreciated. Thanks

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 02 2012 - 08:46:52 CDT