FLASHBACK TABLE对全文索引的影响-备份恢复-Oracle频道-中国IT实验室

SQL> CREATE TABLE T (ID NUMBER, DOCS VARCHAR2(4000));

表已创建。

SQL> ALTER TABLE T ADD CONSTRAINT PK_T PRIMARY KEY (ID);

表已更改。

SQL> SELECT INDEX_NAME, INDEX_TYPE FROM USER_INDEXES WHERE TABLE_NAME = 'T';

INDEX_NAME INDEX_TYPE
------------------------------ ---------------------------
PK_T NORMAL

SQL> DROP TABLE T;

表已删除。

SQL> SELECT OBJECT_NAME, ORIGINAL_NAME, TYPE FROM RECYCLEBIN;

OBJECT_NAME ORIGINAL_NAME TYPE
------------------------------ --------------------------- ------------
BIN$NvibMDOJQFG+eWVDvmWAxQ==$0 PK_T INDEX
BIN$9bC8RcWpTay86d0+hHg1mQ==$0 T TABLE

SQL> FLASHBACK TABLE T TO BEFORE DROP;

闪回完成。

SQL> SELECT INDEX_NAME, INDEX_TYPE FROM USER_INDEXES WHERE TABLE_NAME = 'T';

INDEX_NAME INDEX_TYPE
------------------------------ ---------------------------
BIN$NvibMDOJQFG+eWVDvmWAxQ==$0 NORMAL

--------------------next---------------------

SQL> ALTER INDEX "BIN$NvibMDOJQFG+eWVDvmWAxQ==$0" RENAME TO PK_T;

索引已更改。

SQL> SELECT INDEX_NAME, INDEX_TYPE FROM USER_INDEXES WHERE TABLE_NAME = 'T';

INDEX_NAME INDEX_TYPE
------------------------------ ---------------------------
PK_T NORMAL

--------------------next---------------------