Home » RDBMS Server » Server Utilities » Update using sqlldr
Update using sqlldr [message #328297] Thu, 19 June 2008 12:36 Go to next message
jyo_1906
Messages: 3
Registered: June 2008
Junior Member
Hi,

I need to update the existing data in the table from the contents of a flat file.
Can anyone let me know what is the option to be used with sqlldr?
I get as many as 100K records for update.

Thanks
Jyo
Re: Update using sqlldr [message #328299 is a reply to message #328297] Thu, 19 June 2008 12:42 Go to previous messageGo to next message
BlackSwan
Messages: 25032
Registered: January 2009
Location: SoCal
Senior Member
jyo_1906 wrote on Thu, 19 June 2008 10:36
Hi,

I need to update the existing data in the table from the contents of a flat file.
Can anyone let me know what is the option to be used with sqlldr?
I get as many as 100K records for update.

Thanks
Jyo

no, but you could make the flat file to be an external table & use UPDATE statement. This advice assumes a correct WHERE clause exists.

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above
Re: Update using sqlldr [message #328301 is a reply to message #328299] Thu, 19 June 2008 12:44 Go to previous messageGo to next message
jyo_1906
Messages: 3
Registered: June 2008
Junior Member
Thanks for the reply.
Do you mean that I need to load the file into a seperate table[B] and then update the existing table[A] using the data in the table[B] ?
Re: Update using sqlldr [message #328303 is a reply to message #328297] Thu, 19 June 2008 12:50 Go to previous messageGo to next message
BlackSwan
Messages: 25032
Registered: January 2009
Location: SoCal
Senior Member
I suggest you use the Search capability on the forum for "external table" and/or use GOOGLE for same string plus "oracle".

If the flat file resides on the database server system, Oracle can treat this file as though it is an internal table.
Re: Update using sqlldr [message #328305 is a reply to message #328297] Thu, 19 June 2008 12:57 Go to previous message
jyo_1906
Messages: 3
Registered: June 2008
Junior Member
Thanks I am new to Oracle so I thought external table is a new table.
Previous Topic: Import file to DB
Next Topic: sqlldr
Goto Forum:
  


Current Time: Fri Dec 02 12:36:32 CST 2016

Total time taken to generate the page: 0.11831 seconds