| flash drop in 10g [message #219988] |
Sat, 17 February 2007 06:07  |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
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?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
