Home » RDBMS Server » Server Administration » flash drop in 10g
flash drop in 10g [message #219988] Sat, 17 February 2007 06:07 Go to next message
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?
Re: flash drop in 10g [message #219990 is a reply to message #219988] Sat, 17 February 2007 06:15 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Known bug.
Previous Topic: USED_UREC in v$transaction
Next Topic: Spfile
Goto Forum:
  


Current Time: Sat Dec 03 09:43:01 CST 2016

Total time taken to generate the page: 0.13622 seconds