OraFAQ Forum: Server Utilities » how to load data from several dat files at a time using sqlloader?

Home » RDBMS Server » Server Utilities » how to load data from several dat files at a time using sqlloader?

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

how to load data from several dat files at a time using sqlloader? [message #325410]

Fri, 06 June 2008 02:43

hedonist123
Messages: 119
Registered: August 2007

Senior Member

Hi,

how to load data from several dat files at a time using sqlloader?

My dat file is split into many files

rtxvnd.dat.R0001338
rtxvnd.dat.R0001339
rtxvnd.dat.R0001340
rtxvnd.dat.R0001341
rtxvnd.dat.R0001342

How, do I insert data from all these files?

Or if you could tell me a way to combine all this files into one, that would be great!

Thanks,

Sharath

Report message to a moderator

Re: how to load data from several dat files at a time using sqlloader? [message #325415 is a reply to message #325410]

Fri, 06 June 2008 02:48

S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom

Senior Member

Check this link.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_control_file.htm#sthref688

Regards

Raj

Report message to a moderator

Previous Topic:	Compressed size EXP
Next Topic:	EXPORT PROCEDURES,PACKAGES

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 10:12:43 CST 2024