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.

Report message to a moderator

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: 68651
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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: SQL LOADER -Ora error-01858 and 01843
Next Topic: Exp\Imp from one pc to another pc
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 03:29:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.