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)
Struts (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, 8606👍, 0💬
Popular Posts:
How To Change System Global Area (SGA)? - Oracle DBA FAQ - Introduction to Oracle Database 10g Expre...
What is the difference between CALL_FORM, NEW_FORM and OPEN_FORM? CALL_FORM: start a new form and pa...
What is the version information in XML? “version” tag shows which version of XML is used.
How do we configure “WebGarden”? “Web garden” can be configured by using process model settings in...
What are shared (VB.NET)/Static(C#) variables? Static/Shared classes are used when a class provides ...