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

Report message to a moderator

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

Report message to a moderator

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] ?

Report message to a moderator

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: 26766
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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Import file to DB
Next Topic: sqlldr
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 11:12:28 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.