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