Hi ,
I am setting up a Oracle 12.3 Goldengate for internal testing. We are looking for setup a "File to Database utility" for initial load.
Earlier version of GG documents saying to use "FORMATASCII,SQLLOADER" option in Extract and "GENLOADFILES sqlldr.tpl" in target system.
But When I try with it, its saying
2018-02-22T08:17:22.289-0600 WARNING OGG-02278 Oracle GoldenGate Capture for Oracle, filetou.prm: Output format parameter ASCIIFORMAT is a deprecated parameter.
I checked on 12.3 param and it saying to use of
OUTPUTFORMAT TEXT/SQL/XMl. I do not see any document having the proper use of "how to generate the ASCII formatted file which supports the SQLLOADER".
Then I tried with the below
OUTPUTFORMAT TEXT,SQLLOADER
but this generates the SQL file instead of the ASCII and this file is not recognised in "GENLOADFILES sqlldr.tpl" .
When i Run the load in target, I am getting the
SOURCEDEFS ./dirdat/SOURCE_DEFGEN.def
MAP SONEDBA.FILETOLOADUT,TARGET SONEDBA.FILETOLOADUT;
2018-02-23 04:09:31 INFO OGG-06451 Triggers will be suppressed by default.
Load files generated successfully.
But no files getting generated.
Can anyone have the idea about how to use this features in 12.3 ?.