My Oracle Support Banner

Enabling USE_SCALAR_TYPES_FOR_VALIDTIME has no effect on the XXX_LOCK view (Doc ID 1927281.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Workspace Manager - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

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:

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.