| Need Suggestion [message #405809] |
Fri, 29 May 2009 11:18  |
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 #405818 is a reply to message #405809] |
Fri, 29 May 2009 13:10  |
joy_division
Messages: 4963
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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
