My Oracle Support Banner

After Doing Import With SCALE Defined On TIMESTAMP Columns Gets Missing (Doc ID 2871598.1)

Last updated on MAY 23, 2022

Applies to:

Oracle GoldenGate Veridata - Version and later
Information in this document applies to any platform.


After doing import with, SCALE defined on TIMESTAMP columns gets missing:

In order to refresh or deploy new config between environments, customer uses "" and "" scripts.


Step 1) After export is done with "", it can be verified that "scale" config of some "timestamp" columns are exported correctly.
Step 2) After IMPORT is done with "" from the file from Step 1), it is found that attribute "scale" are missing or are ignored by import.
Step 3) It can also be verified in GUI or with simple export again, that there are no "scale" attribute now in the timestamp columns.


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.