OraFAQ Forum: Server Utilities » Using sqlldr to load multiple tables

Home » RDBMS Server » Server Utilities » Using sqlldr to load multiple tables

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

Using sqlldr to load multiple tables [message #110691]

Wed, 09 March 2005 12:33

beast
Messages: 1
Registered: March 2005

Junior Member

I have to FTP files from an AS400 to the Oracle server. Then I have to load the tables simultaneously so that Oracle can see the key between these two tables. Does anyone have any examples I can start with? Are there any peculiarities I need to be aware of? Can I do this using sqlldr as part of a Unix script, or do I need to go over to PL/SQL?

Report message to a moderator

Re: Using sqlldr to load multiple tables [message #110932 is a reply to message #110691]

Fri, 11 March 2005 03:34

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

Depending on your requirements, SQL*Loader should do just fine. Look at the examples of loading into multiple tables simultaneously in the Oracle Utilities Users Guide. Also, have a look at this: Can one load data into multiple tables at once?

Best regards.

Frank

Report message to a moderator

Previous Topic:	export file not updating foir long time while export is running
Next Topic:	SQL loader Variable length field was truncated

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 08:46:00 CDT 2024