Home » RDBMS Server » Server Utilities » Loadin filename in a table (10G)
Loadin filename in a table [message #301448] Wed, 20 February 2008 12:14 Go to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
All
I am loading multiple files through sqlldr in a table, This table has one column called filename, How do i populate this column with file name which is being loaded. Any help is appreciated.

Thanks
Re: Loadin filename in a table [message #301449 is a reply to message #301448] Wed, 20 February 2008 12:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to put it as a constant in the control file that you can dynamically generates each time.

Regards
Michel
Re: Loadin filename in a table [message #301450 is a reply to message #301449] Wed, 20 February 2008 12:27 Go to previous messageGo to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
I can generate control file one for each datafile??
Re: Loadin filename in a table [message #301453 is a reply to message #301450] Wed, 20 February 2008 12:39 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Yes.
just search the forum.
Way too many examples. Exact method depends on OS.
Previous Topic: importing data from 9i to 8i
Next Topic: Multiple WHEN conditions in SQL*Loader
Goto Forum:
  


Current Time: Sun Dec 11 02:31:55 CST 2016

Total time taken to generate the page: 0.04427 seconds