OraFAQ Forum: Replication » a question about initial load file to database utility method (merged)

Home » Server Options » Replication » a question about initial load file to database utility method (merged) (OGG, 12c, linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

a question about initial load file to database utility method (merged) [message #677170]

Wed, 28 August 2019 13:33

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

Report message to a moderator

initial load file to database utility method [message #677175 is a reply to message #677170]

Wed, 28 August 2019 17:38

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Oct 04 22:46:52 CDT 2023