Home » SQL & PL/SQL » SQL & PL/SQL » Update in huge data in partitioned table (oracle 10g)
Update in huge data in partitioned table [message #379327] Tue, 06 January 2009 01:31 Go to next message
someswar1
Messages: 53
Registered: January 2008
Member
Hi,
I have a one partioned table which has 20 million data. I want to update some column of this table. but it takes huge time . can any one say is there any way to reduce time of update satement or which hints are applicable to produce better results in update statement .

please help its urgent.

Thanks & Regards

Someswar
Re: Update in huge data in partitioned table [message #379329 is a reply to message #379327] Tue, 06 January 2009 01:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No way from what you said.

Regards
Michel
Re: Update in huge data in partitioned table [message #379330 is a reply to message #379327] Tue, 06 January 2009 01:52 Go to previous messageGo to next message
flyboy
Messages: 1903
Registered: November 2006
Senior Member
Maybe you may study this thread on AskTom: How to Update millions or records in a table
and then re-think the necessity of updating a column.
Re: Update in huge data in partitioned table [message #379603 is a reply to message #379327] Wed, 07 January 2009 05:07 Go to previous messageGo to next message
hasan_uiu
Messages: 18
Registered: August 2007
Location: Dhaka
Junior Member

1. First enable row movement of your table
2. disable all index

then try to update


---

Hasan


[Updated on: Wed, 07 January 2009 05:45] by Moderator

Report message to a moderator

Re: Update in huge data in partitioned table [message #379615 is a reply to message #379603] Wed, 07 January 2009 06:13 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
How does enabling row movement contribute to a better performance of a huge update??
Re: Update in huge data in partitioned table [message #379616 is a reply to message #379615] Wed, 07 January 2009 06:24 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Frank wrote on Wed, 07 January 2009 13:13
How does enabling row movement contribute to a better performance of a huge update??


Hmm I also wonder ?

Besides the update, I think it's a bad advice, since it might corrupt "features" that relies on ROWID

[Updated on: Wed, 07 January 2009 06:28]

Report message to a moderator

Re: Update in huge data in partitioned table [message #379617 is a reply to message #379615] Wed, 07 January 2009 06:31 Go to previous message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
As for most of his posts, the purpose of this one is just to put a link to his blog (that I systematically remove).

Regards
Michel
Previous Topic: Accessing other user's objects
Next Topic: Query about the in-built functions in Oracle
Goto Forum:
  


Current Time: Tue Nov 12 23:04:05 CST 2024