drop table u1;drop table u1*ERROR at line 1:ORA-55610: Invalid DDL statement on history-tracked table 查詢錯誤原因 $ oerr ora 55..."/>
您好,登錄后才能下訂單哦!
SQL> drop table u1;
drop table u1
*
ERROR at line 1:
ORA-55610: Invalid DDL statement on history-tracked table
$ 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.
原來是之前開了閃回日志歸檔,不能執(zhí)行部分的DDL操作
select table_name,flashback_archive_name from dba_flashback_archive_tables;
TABLE_NAME FLASHBACK_ARCHIVE_NAME
1 U1 TEST1
SQL> alter table u1 no flashback archive;
Table altered.
SQL> drop table u1;
Table dropped.
免責聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。