My Oracle Support Banner

OAC: Special Characters (Double Quote And Forward Slash) loading With NULL Values In Data Sync (Doc ID 2519288.1)

Last updated on MARCH 10, 2021

Applies to:

Oracle Analytics Cloud - Classic - Version N/A and later
Information in this document applies to any platform.


On Oracle Analytics Cloud - Classic: Data Sync 2.5

OAC Data Sync “special character” (Double quote and Forward slash) are loading with NULL values.
Due to this Null values the load fails with "ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found."
Source system have these characters '/'," ", then in target DB table these values are loaded as null in LOOKUPCODE columns (which is a primary key column).

ERROR from Data sync log
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found




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.