Home » RDBMS Server » Server Utilities » Need Suggestion (Oracle-10g)
Need Suggestion [message #405809] Fri, 29 May 2009 11:18 Go to next message
sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai
Member

Hello To All,

1.I need some suggestion my problem is that i am loading data in a table using SQLLOADER in a table.
2.But after loading some data my data is replace suach as col1 data is loaded into col2 ,col2 data is loaded into col3 so on.
3.Size of my table is very high.
Can you tell how can i update data to its orignal column posiotion

[Updated on: Fri, 29 May 2009 11:42] by Moderator

Report message to a moderator

Re: Need Suggestion [message #405811 is a reply to message #405809] Fri, 29 May 2009 11:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not with what you posted.

Regards
Michel
Re: Need Suggestion [message #405818 is a reply to message #405809] Fri, 29 May 2009 13:10 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
sr_orcl wrote on Fri, 29 May 2009 12:18
H
Can you tell how can i update data to its orignal column posiotion


update table set col1=col2, col2=col3, col3=col4, etc.


But this will effectively replace 100% of your data, generating a massive amount of undo/redo.
Re: Need Suggestion [message #405823 is a reply to message #405818] Fri, 29 May 2009 13:33 Go to previous messageGo to next message
sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai
Member

but my data is in GB how cani increase the speed of update statement
Re: Need Suggestion [message #405824 is a reply to message #405823] Fri, 29 May 2009 13:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why don't you load in the correct columns?
Or if all the rows are wrong why don't you just rename the columns?

Regards
Michel
Re: Need Suggestion [message #405828 is a reply to message #405824] Fri, 29 May 2009 14:00 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Or you could buy faster hardware.
Previous Topic: impdp is not using parallelism (2 merged)
Next Topic: How to run TKPROF on Oracle9i(9.0.1)
Goto Forum:
  


Current Time: Tue Dec 06 04:20:43 CST 2016

Total time taken to generate the page: 0.09220 seconds