Re: Can't drop a table, even as sysdba
- From: "Rodrigo Mufalani" <rodrigo@xxxxxxxxxxxxxxx>
- To: tomdaytwo@xxxxxxxxx
- Date: Thu, 2 Aug 2012 10:53:58 -0300
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
