My Oracle Support Banner

Error ORA-20229 On When Enabling Versioning On Table With Nvarchar2 PK (Doc ID 1449638.1)

Last updated on MARCH 11, 2020

Applies to:

Workspace Manager - Version 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.

- all works OK.
- 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.