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

From: Thomas Day <tomdaytwo@xxxxxxxxx>
To: mark.powell2@xxxxxx
Date: Thu, 2 Aug 2012 13:08:32 -0400

Looked for triggers with just DROP.  Fifteen of them.  Disabled one-by-one.
The bad boy was MDSYS SDO_GEOR_DROP_USER.  Not sure why this was affecting
the drop or truncate of an existing table.  When I disabled this things
seemed to work fine.  I'm still investigating.

--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- Re: Can't drop a table, even as sysdba
  - From: Norman Dunbar

References:
- Can't drop a table, even as sysdba
  - From: Thomas Day
- RE: Can't drop a table, even as sysdba
  - From: Powell, Mark

Other related posts:

» Can't drop a table, even as sysdba- Thomas Day
» Re: Can't drop a table, even as sysdba- Tim Gorman
» Re: Can't drop a table, even as sysdba- Rodrigo Mufalani
» Re: Can't drop a table, even as sysdba- Thomas Day
» RE: Can't drop a table, even as sysdba- Powell, Mark
» Re: Can't drop a table, even as sysdba - Thomas Day
» Re: Can't drop a table, even as sysdba- Norman Dunbar