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 next 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

initial load file to database utility method [message #677175 is a reply to message #677170] Wed, 28 August 2019 17:38 Go to previous message
lozity
Messages: 2
Registered: August 2019
Junior Member
I want to use GG to generate a run file and a sql*loader control file, but something wrong ...

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]$ replicat paramfile dirprm/initrep.prm reportfile dirrpt/t1.txt



Then I got these errors:

[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



I think this control file cannot use absolutely.

[Updated on: Wed, 28 August 2019 17:40]

Report message to a moderator

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


Current Time: Wed Dec 11 16:24:52 CST 2019