Re: Can't drop a table, even as sysdba
- From: Tim Gorman <tim@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 02 Aug 2012 07:46:52 -0600
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
