Saturday 28 March 2020

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


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

This error comes when you are trying to drop tables and flashback enabled for the table.

Select OWNER_NAME,TABLE_NAME,FLASHBACK_ARCHIVE_NAME,STATUS from dba_flashback_archive_tables where table_name = 'DEPT';

 If the table is listed with status is enabled from the dba_flash_archive_tables, then i will not allow to drop the table. you need to disable the flashback.

below command will disable the flashback of the table.

alter table DEPT no flashback archive;

how you can drop the table.

1 comment:

  1. its like only entry door, no EXIT door..!!
    u gave command to disable, how to enable now ?

    ReplyDelete