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