ORA-55610: Invalid DDL statement on history-tracked 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.
its like only entry door, no EXIT door..!!
ReplyDeleteu gave command to disable, how to enable now ?