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

From: Powell, Mark <mark.powell2_at_hp.com>
Date: Thu, 2 Aug 2012 14:36:55 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD1092D7382_at_G6W2479.americas.hpqcorp.net>

What happens if you remove the purge?

I think it is a bad idea to ever create non-Oracle provided objects in the SYS schema. Every object owned by user SYS should be created via the install or running an Oracle provided script otherwise you should be using "create table username.junk";

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thomas Day Sent: Thursday, August 02, 2012 9:39 AM
To: oracle-l
Subject: Can't drop a table, even as sysdba

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Aug 02 2012 - 09:36:55 CDT