[Oracle problem set 5] ORA-55622: DML, alter and create unique index operations are not allowed on table

Note: [Oracle problem set] refers to the problems and solutions encountered by bloggers during database operations.

Statement execution: indicates the database operation process. Error: Indicates An error occurred while operating the database. Error cause: indicates the cause of the error. Solution: indicates the solution to the error. Related Knowledge: indicates the knowledge related to this topic. ========================================================== ======================================Execution statement: an error is reported when the tablespace name is dropped. The following error occurs:

ORA-55622: DML, alter and create unique index operations are not allowed on table "proc". "sys_fba_tcrv_76187"

Cause of error: the user wants to delete the tables with the authorized flash back features. Solution: revoke the permission granted to the corresponding tables.

1. Find the table with the error
"Proc". "sys_fba_tcrv_76187" where 76187 is the authorization number of the ID in the Flash archive.
SQL> select object_id, owner, object_name from dba_objects where object_id = '20140901'
Object_id ownerobject_name
------------------------------------------------------------
76187 proc test017
2. Find out all tables in the authorized flash back archive (the owner needs to log on and allow, for example, Proc)
SQL> select table_name from user_flashback_archive_tables;
Table_name
------------------------------
Test017
3. Reclaim the flash archive function in the table
Alter table <owner>. <tablename> No flashback archivew;
4. Execute the tablespace deletion command.
Drop tablespace tablename including contents and datafiles;

Related Knowledge: flashback Archive