Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
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, 8206👍, 0💬
Popular Posts:
How was XML handled during COM times? During COM it was done by using MSXML 4.0. So old languages li...
How to create arrays in JavaScript? We can declare an array like this var scripts = new Array(); We ...
Explain in detail the fundamental of connection pooling? When a connection is opened first time a co...
Which are the various programming approaches for WCF?
Which bit wise operator is suitable for checking whether a particular bit is on or off? The bitwise ...