Showing results for 
Search instead for 
Do you mean 

How can a User Drop an Index on a Version Enabled Table if the DBMS_WM.BeginDDL Command cannot be Used?

by Anonymous on ‎02-23-2016 09:12 AM - edited on ‎04-06-2016 11:16 AM by Moderator (311 Views)

Question

How can a user drop an Index on a version enabled table if the DBMS_WM.BeginDLL command cannot be used? 

Answer

As the user that owns the table, run the following:

 

exec wmsys.lt_ctx_pkg.allowDDLOperation('true');

 

then drop the index on NEXTVER,

 

SELECT INDEX_NAME FROM USER_IND_COLUMN WHERE TABLE_NAME='GEONAME_FEATURE_LT' AND COLUMN_NAME='NEXTVER';

 

DROP INDEX <indexname>;

 

If the index drops OK then:

 

exec wmsys.lt_ctx_pkg.allowDDLOperation('false');

 

Then try to use beginDDL. It shold work now.

Contributors