Using OGGBD21c To S3 : T Seperator Is Missing For Current_ts In The Initial Load (Doc ID 2977857.1)

Last updated on JULY 20, 2024

Applies to:

Oracle GoldenGate Big Data and Application Adapters - Version 21.4.0.0.0 and later
Information in this document applies to any platform.

Goal

We are replicating from Oracle database to AWS S3 using 21c GG for big data and we used following metaColumnsTemplate in 21c Java properties files to write the all the following options but the current_ts is missing the T separator in the file format.

In initial load the current_ts format is missing the T separator and its creating the issues.

current_ts in case of initial load using 21c GG : 2023-08-05 03:52:06.002000
current_ts in ongoing CDC replication using 19c GG : 2023-08-08T00:19:25.163000

please advise how to have T separator for all the fields in the initial load using 21c GG also on-going replication?

Solution

	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

Goal

Solution

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

Using OGGBD21c To S3 : T Seperator Is Missing For Current_ts In The Initial Load (Doc ID 2977857.1)

Applies to:

Goal

Solution

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

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