Flashback drop
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Flashback drop

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    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?

  2. #2
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    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
  •  



Click Here to Expand Forum to Full Width