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.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 16 2004 - 11:54:14 CST
