Can't drop a table, even as sysdba

From: Thomas Day <tomdaytwo_at_gmail.com>
Date: Thu, 2 Aug 2012 09:39:11 -0400
Message-ID: <CAMa2=-dP0ncym0C5EvNMyTTfekdyDB9Vui0imEbkHYXnf2EQAA_at_mail.gmail.com>

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:39:11 CDT