Home » RDBMS Server » Server Utilities » How to combine multiple control files in SQL*Loader (Oracle 9i)
How to combine multiple control files in SQL*Loader [message #352413] Tue, 07 October 2008 08:58 Go to next message
Bonita
Messages: 32
Registered: June 2008
Member
Oracle 9.2.

I have three command files A,B and C, and load data to three tables A1,B1, and C1. Control files ( A,B,C ) and tables ( A1,B1,C1 ) are different, and use different csv files as source.

How do I only use one control file to combine A ( load to A1 ) ,B ( load to B1 ) ,C ( ( load to C1 ) and get job done at one time . Could you please show me how.

Thank you for your time and reply.
Re: How to combine multiple control files in SQL*Loader [message #352427 is a reply to message #352413] Tue, 07 October 2008 10:11 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why?

Regards
Michel
Previous Topic: exp hangs at cluster definitions (merged)
Next Topic: How to use OR in WHEN clause?
Goto Forum:
  


Current Time: Sat Dec 03 11:51:50 CST 2016

Total time taken to generate the page: 0.05083 seconds