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

From: Rodrigo Mufalani <rodrigo_at_mufalani.com.br>
Date: Thu, 2 Aug 2012 10:53:58 -0300
Message-ID: <344ac4a24fbafe88bf853b3a61b12940.squirrel_at_webmail.mufalani.com.br>

Hi Buddy,

   I tested on 11.2.0.3 (linux), investigate triggers "BEFORE DROP" on your env.

Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

SQL>
create table junk (junk number);

drop table junk purge;SQL>
Table created.

SQL> SQL> Table dropped.

Best Regards,

Rodrigo Mufalani
Oracle Ace
Member
http://www.mufalani.com.br

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 - 08:53:58 CDT