-
Flashback drop
i am testing flashback drop on 10g
i have a table which also have defined index on empno
CREATE TABLE TEST_EMP (
EMPNO NUMBER (4),
ENAME VARCHAR2 (10),
JOB VARCHAR2 (9),
MGR NUMBER (4),
HIREDATE DATE,
SAL NUMBER (7,2),
COMM NUMBER (7,2),
DEPTNO NUMBER (2))
CREATE INDEX indx_empno ON
TEST_EMP(EMPNO);
1-i have drop the table by using
drop table test_emp
2-then i use flash table test_emp to before drop
Table is successfully restored and also its associated index
but when i see the index name it displays
BIN$6CqBU//NTEie3fWjBaeXmQ==$0 instead of indx_empno after flashback table
this name is quite ambiqious ,should i have to recreate the index with proper name
or anything else?
-
Indexes are not renamed back to original names when you do flashback table. No need to recreate the table, just rename it using following syntax,
ALTER INDEX "Your_encrypted_index_name" RENAME TO original_index_name;
-- Dilip
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|