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

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


Other related posts: