Showing results for 
Search instead for 
Do you mean 

How can the restriction on DDL operations for secured tables be overridden for GeoMedia?

by Technical Evangelist on ‎03-15-2016 08:20 AM - edited on ‎04-06-2016 02:18 PM by Moderator (268 Views)

Question

Is there a means to override the restriction on DDL operations for secured tables used with GeoMedia?

Answer

The _LTS staging table created by beginddl will only contain columns from the original table. You will not be able to add indexes to any columns added by the version enabling process, like RETIRETIME.   To do this, you have to override the DDL lock on the _LT table.

 

There is a hidden command that will do this:

EXEC WMSYS.LT_CTX_PKG.ALLOWDDLOPERATION('TRUE');

 

Now you should be able to directly affect any _LT table. Be very careful because changes here could have dire effects. It has been used successfully to add or remove indexes from _LT table. Do not use it to add or remove columns.

 

When you are done, run the following to exit the DDL mode.

EXEC WMSYS.LT_CTX_PKG.ALLOWDDLOPERATION('FALSE');

 

If this operation is performed, beginDDL cannot be used until any user defined indexes on _LT have been dropped.

Contributors