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 (See ORA-38301.ora-code.com): can not perform DDL/DML over objects in Recycle Bin
>
> thank
you.
