Shulou(Shulou.com)06/01 Report--

An error was reported when deleting the table

SQL > drop table U1

Drop table u1

*

ERROR at line 1:

ORA-55610: Invalid DDL statement on history-tracked table

Query the cause of the error

$oerr ora 55610

55610, 00000, "Invalid DDL statement on history-tracked table"

/ / Cause: An attempt was made to perform certain DDL statement that is

/ / disallowed on tables that are enabled for Flashback Archive.

/ / Action: No action required.

It turns out that the flashback log archive was opened before, and cannot perform part of the DDL operation.

Select table_name,flashback_archive_name from dba_flashback_archive_tables

TABLE_NAME FLASHBACK_ARCHIVE_NAME

1 U1 TEST1

Treatment method

SQL > alter table U1 no flashback archive

Table altered.

SQL > drop table U1

Table dropped.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.