Enabling USE_SCALAR_TYPES_FOR_VALIDTIME has no effect on the XXX_LOCK view
Last updated on SEPTEMBER 17, 2014
Applies to:Workspace Manager - Version 220.127.116.11 to 18.104.22.168 [Release 12.1]
Information in this document applies to any platform.
After setting the system paramter USE_SCALAR_TYPES_FOR_VALIDTIME to ON and version-enabled a table, the xxx_LOCK view is still created with the WM_VALID column instead of two columns named WM_VALIDFROM and WM_VALIDTILL:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms