RE: Drop user fails with ORA-01418

  • From: Natural Join B.V. <lex.de.haan@xxxxxxxxxxxxxx>
  • To: chadi@xxxxxxxxxxxxxxxxxx, "'William B Ferguson'" <wbfergus@xxxxxxxx>, thomas.mercadante@xxxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 16 Nov 2004 17:53:37 MET

what's the complete information from the recyclebin regarding this object?
try "select * from dba_recyclebin where <some appropriate where clause> ...
indeed, recycle bin objects are read only by nature!

> I did all of that...
> purge dba_recyclebin
> purge recyclebin
> purge user_recyclebin
> 
> when I try to delete the object in question, even after purging the
> recyclebin, it gives:
> 
> SQL Error 
> ORA-38301: can not perform DDL/DML over objects in Recycle Bin  
> 
> thank
you.

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

Other related posts: