ORA-55622: DML, ALTER and create unique index operations are

ORA-55622: DML, ALTER and create unique index operations are not allowed on table execute statement: delete tablespace reports error, drop tablespace name error symptom: ORA-55622: DML, ALTER and create unique index operations are not allowed on table "PROC ". "SYS_FBA_TCRV_76187" error cause: the user wants to delete the tables with the authorized flash back features. Solution: revoke the permission granted to the corresponding table. 1. Find the table with the error "PROC ". "SYS_FBA_TCRV_76187" where 76187 is the authorization number of the ID in the flash back archive SQL> select object_id, owner, object_name from dba_objects where object_id = '000000' OBJECT_ID OWNER OBJECT_NAME ---------------------- expose 76187 PROC TEST0172. Find all tables in the authorization flashback archive (the owner must log on and allow, for example, proc) SQL> select table_name from user_flashback_archive_tables; TABLE_NAME ------------------------------ TEST0173. Remove the flashback archive function in the table alter table <owner>. <tablename> no flashback archivew; 4. Run the drop tablespace tableName including contents and datafiles command to delete the tablespace;