Error ORA-20229 On 18.104.22.168 When Enabling Versioning On Table With Nvarchar2 PK
(Doc ID 1449638.1)
Last updated on MARCH 11, 2020
Applies to:Workspace Manager - Version 22.214.171.124 and later
Information in this document applies to any platform.
When a table with a PK column of type NVARCHAR2 is version-ed it generates an error.
If the type of column a is VARCHAR2 the the table can be version-ed OK.
- 126.96.36.199 all works OK.
- 188.8.131.52 has the error.
Simple test case shows the problem.
ERROR at line 1:
ORA-20229: statement 'CREATE TABLE TEST(A NVARCHAR2(10 char),
ChildState varchar2(30)' failed during EnableVersioning. Error:
ORA-00907: missing right parenthesis
ORA-06512: at "WMSYS.LT", line 9179
ORA-06512: at line 1
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