"Translated from MOS article" encountered error in Alter/drop tablespace ora-38301,ora-00604,purge dba_recyclebin.

Error encountered while Alter/drop table space Ora-38301,ora-00604,purge Dba_recyclebin not

Suitable for:
Oracle database-enterprise edition-version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms:
When you try to drop an empty tablespace, you encounter RecycleBin-related errors

Sql> drop tablespace Test_tbs including contents and datafiles; Drop tablespace Test_tbs including contents and Datafiles * ERROR at line 1:ora-00604:error occurred at recursive SQL le Vel 1 ora-38301:can not perform ddl/dml over objects in Recycle Bin

Try purge Dba_recyclebin and offline the tablespace:

Reason:
Query dba_segments shows that there are segments in the table space

Sql> Select Segment_name,segment_type,owner from dba_segments where tablespace_name= ' Test_tbs '; Segment_name                   segment_type       OWNER----------------------------------------------------------------------- -------bin$pks1anxmmctgq8+ct10wja==$0 table              ORACLE      bin$pks790fcqezgq8+ct11ata==$0 table              

Solution:

Log in Sqlplus with the owner of the schema, then execute purge recyclebin, and then delete the drop tablespace

If this still does not solve the problem, the quickest way to work is to disable off RecycleBin, then drop tablespace, and then enable Recyclbin

Sql> conn/as sysdbasql> alter system set Recyclebin=off; Sql> drop tablespace Test_tbs including contents and datafiles; Sql> alter system set Recyclebin=on;

---Remind: 11gr2 inside, RecycleBin seems to be static parameters.

If the above steps do not solve the problem, please use the following method:

1) sqlplus/as sysdba2) ALTER SYSTEM SET recyclebin = OFF deferred;3) Disconnect and exit SQLPLUS4) Sqlplus/as Sysdba5) Drop tablespace ... 6) Sqlplus/as Sysdba7) ALTER SYSTEM SET recyclebin = on DEFERRED; or ALTER SYSTEM SET recyclebin = on;

"Translated from MOS article" encountered error in Alter/drop tablespace ora-38301,ora-00604,purge dba_recyclebin.