Home » Server Options » Replication » a question about initial load file to database utility method (merged) (OGG, 12c, linux)
a question about initial load file to database utility method (merged) [message #677170] Wed, 28 August 2019 13:33 Go to previous message
lozity
Messages: 2
Registered: August 2019
Junior Member
I wanna use OGG to copy data with file to database utility method, oracle to oracle, to generate a run file and sql*loader control file, but I cannot get any run file and control file is a wrong one, please help me...

GGSCI (zccc.domain11.example.com) 1> view param initrep



GENLOADFILES sqlldr.tpl

--SETENV (ORACLE_HOME='/u01/app/oracle/12.2.0/db_1')

SETENV (ORACLE_SID='xiyun')

USERID ggadmin, password ggadmin

EXTFILE ./dirdat/at1

ASSUMETARGETDEFS

MAP A.*, TARGET A.*;


[oracle@zccc ogg_src]$ cat sqlldr.tpl

#

# File Names

#

controlfile ?target.ctl

runfile ?target.run





#

# Run File Template

#

sqlldr userid=?pw control=?target log=?target direct=true

#

# Control File Template

#

unrecoverable

load data

infile ?source.dat

truncate

into table ?target

 
Read Message
Read Message
Previous Topic: XAG-237 occurred when configured GoldGaten with XAG in RAC
Next Topic: Column replication
Goto Forum:
  


Current Time: Fri Mar 29 05:00:17 CDT 2024