Categories:
.NET (357)
C (330)
C++ (184)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (2)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Recover a Dropped Index
How To Recover a Dropped Index? - Oracle DBA FAQ - Managing Oracle Table Indexes
✍: 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
2007-05-02, 8588👍, 0💬
Popular Posts:
What is the value of this expression? +1-2*3/4 -0.5
What is the difference between Class and structure’s ? Following are the key differences between the...
How To Compile a JUnit Test Class? Compiling a JUnit test class is like compiling any other Java cla...
What is synchronization and why is it important? With respect to multithreading, synchronization is ...
How do we configure “WebGarden”? “Web garden” can be configured by using process model settings in...