Tuesday, June 28, 2011

INDEX creation on versioned tables.

In the below example table name is "TEST"


EXEC DBMS_WM.enableVersioning('TEST');


exec dbms_wm.beginddl('TEST');

create index index_name on test_lts(ID);

you can drop index on same condition.

drop index index_name;

exec dbms_wm.commitddl('TEST');


Cheers!!!

No comments:

Post a Comment