Collections:
Recover a Dropped Index in Oracle
How To Recover a Dropped Index in Oracle?
✍: FYIcenter.com
If you have the recycle bin feature turned on, dropped indexes are stored in the recycle bin. But it seems to be command to restore a dropped index out of the recycle bin. FLASHBACK INDEX is not a valid statement. See the following script:
ALTER SESSION SET recyclebin = on; Statement processed. CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VARCHAR(80) NOT NULL, birth_date DATE NOT NULL, social_number VARCHAR(80) UNIQUE NOT NULL); Table created. CREATE INDEX student_birth_date ON student(birth_date); Index created. DROP INDEX STUDENT_BIRTH_DATE; Index dropped. SELECT object_name, original_name, type, droptime FROM recyclebin; OBJECT_NAME ORIGINAL_NAME TYPE DROPTIME ----------------------- ------------------ ----- ---------- BIN$1LlsjTxERKq+C7A==$0 STUDENT_BIRTH_DATE INDEX 2006-04-01 FLASHBACK INDEX student_birth_date TO BEFORE DROP; ORA-00905: missing keyword
⇒ Recovered Tables with Indexes in Oracle
⇐ Dropped Tables with Indexes in Oracle
2019-04-22, 4000🔥, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...