7 Replies Latest reply on Mar 5, 2008 11:46 PM by stevencallan

    table cannot be dropped. ORA-38301:

      I have serevral objects as below in my database.


      when I tryied to drop or remove data got message as below:

      " Dropping a table removes the table definition from the data dictionary. All rows of the table are no longer accessible. All associated indexes and triggers are dropped. ....
      Are u sure u want to remove table SHEMA_NAME.

      I click on yes.
      Got message as below:

      " VBO-4562: table cannot be dropped. ORA-38301: can not perform DDL/DML over objects in Recycle Bin".

      How to delete objects/
      Why and how they have been created?