Ora-55622 does not allow DML, alter and create unique index operations on table “XXX”

Time:2021-4-8

Error Description:When deleting users and table spaces, it is reported that ora-55622 does not allow DML, alter and create unique index operations on table “XXX”. The specific error information is as follows:

drop user TJ_CZDJ_GX cascade;

QQ截图20210104095852

Error reason:After checking, “sys”_ FBA_ TCRV_ The table named “XXX” is the table used by the database file, which is mainly responsible for recording the information of specific operations in a specific time range.

Flashback archive is mainly used to save the change data of some tables for a long time, for auditing, etc. when deleting the table space, you need to close the flashback archive first.

You can use the following statement to see which tables are opened by all users.

select * from dba_flashback_archive_tables;

In addition, you can view the specific error reporting table through the following statement according to the prompt:

select object_id,owner,object_name from dba_objects t where t.object_id=217444;

Among them, 217444 is “sys” in error information_ FBA_ TCRV_ The “XXX” table indicates the contents of XXX.

image

resolvent:Close the flash file of the corresponding table.

You can close the file of the specified table by the following statement:

alter table XXX no flashback archive;

Because I have multiple tables with flash return files on, for convenience, I can directly build multiple statements to close flash return files and execute them in batches (note that the constructed alter statements are executed under the current user. If you want to execute them under sys, you need to add a user name prefix, that is, the format of user name and table name).

select ‘alter table ‘ || table_name || ‘ no flashback archive ;’
   from dba_flashback_archive_tables;

image

Execute drop user TJ again_ CZDJ_ GX cascade; statement, ora-55622 error is no longer prompted.

In addition, users who cannot delete the current connection will be prompted during execution:

image

We can go directly to the tool > session and terminate the session that needs to delete the user.

image

Recommended Today

asp.net Application of regular expression

1. Balanced group / recursive matching (?’ Group ‘), which is called the corresponding content of group, and counts it on the stack;(?’- Group ‘), and count the corresponding content named group out of the stack(?!) Zero width negative look ahead assertion. Since there is no suffix expression, attempts to match always failRegular example:,{0,1}”5″:\[[^\[\]]*(((?’Open’\[)[^\[\]]*)+((?’-Open’\])[^\[\]]*)+)*(?(Open)(?!))\],{0,1} Test […]