OraFAQ Forum: Server Utilities » Loadin filename in a table

Home » RDBMS Server » Server Utilities » Loadin filename in a table (10G)

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

Loadin filename in a table [message #301448]

Wed, 20 February 2008 12:14

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

Report message to a moderator

Re: Loadin filename in a table [message #301449 is a reply to message #301448]

Wed, 20 February 2008 12:22

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Loadin filename in a table [message #301450 is a reply to message #301449]

Wed, 20 February 2008 12:27

toshidas2000
Messages: 120
Registered: November 2005

Senior Member

I can generate control file one for each datafile??

Report message to a moderator

Re: Loadin filename in a table [message #301453 is a reply to message #301450]

Wed, 20 February 2008 12:39

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Yes.
just search the forum.
Way too many examples. Exact method depends on OS.

Report message to a moderator

Previous Topic:	importing data from 9i to 8i
Next Topic:	Multiple WHEN conditions in SQL*Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 22:12:57 CST 2024