My Oracle Support Banner

Reorder Columns in the OGG Trail for OGG Adapter (Doc ID 2193601.1)

Last updated on MAY 11, 2022

Applies to:

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


is it possible to reorder the columns in the flat file adaptor. For example

Source table : column1, colum2,column 3,column 4, column 5,column 6, column 7

Out of which we are extracting column1, colum2,column 4, column 5,column 6, column 7 using cols in extract parameter.

So the Question is : in the flat file adaptor , i need to extract data in below format.

column7,colum2,column 4, column 5,column 6,column1

so the output DSV file will have data in this order.

How can i achieve this ?

call me for any clarifications


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.