Home » RDBMS Server » Server Utilities » How to load mutiple Variable length flat files into multiple tables (Oracle 9i, release 2, unix)
How to load mutiple Variable length flat files into multiple tables [message #302090] Sat, 23 February 2008 05:54 Go to next message
shyam538
Messages: 6
Registered: February 2008
Junior Member
Hello,
How can i load multiple variable length flat files (delimiter separated record files) into multiple tables.

i have done it with fixed lenght flat files. But, i am unable to perform it with variable lenght flat files has i am not knowing where to keep this INTO clause.
Re: How to load mutiple Variable length flat files into multiple tables [message #302101 is a reply to message #302090] Sat, 23 February 2008 09:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at Multiple WHEN conditions in SQL*Loader topic a couple of days ago.

Regards
Michel
Re: How to load mutiple Variable length flat files into multiple tables [message #302158 is a reply to message #302101] Sun, 24 February 2008 04:01 Go to previous message
shyam538
Messages: 6
Registered: February 2008
Junior Member
thanks mike,
sorry i could have checked the forums first.
Previous Topic: SQL LOADER -Ora error-01858 and 01843
Next Topic: Exp\Imp from one pc to another pc
Goto Forum:
  


Current Time: Sun Dec 04 18:55:13 CST 2016

Total time taken to generate the page: 0.23669 seconds