Home » SQL & PL/SQL » SQL & PL/SQL » History Correction
History Correction [message #342306] Fri, 22 August 2008 00:11 Go to next message
gauravsunil
Messages: 68
Registered: August 2007
Location: bhubaneswar
Member
Hi,

I have to do history data correction in table having 1 billion record, I have to do correction between 3 months timestump.
There is index on that time stump.
Please advice, what should be the best way to go for it.

Thanks and regards,
Gaurav
Re: History Correction [message #342307 is a reply to message #342306] Fri, 22 August 2008 00:15 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
What are you trying to do.Please show us that.

Please clarify your post.You have not clarified what opeartion you are performing on the table.

./fa/3314/0/

Regards,
Rajat
Re: History Correction [message #342308 is a reply to message #342306] Fri, 22 August 2008 00:16 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

The optimal performance is obtained with a mauve database indexed by left orthoganal index displacement.
Re: History Correction [message #342312 is a reply to message #342306] Fri, 22 August 2008 00:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"delete table where timestamp column between the wanted dates."

Regards
Michel
Re: History Correction [message #342348 is a reply to message #342312] Fri, 22 August 2008 01:50 Go to previous messageGo to next message
gauravsunil
Messages: 68
Registered: August 2007
Location: bhubaneswar
Member
Michel, I have to update it.

Regards,
Gaurav
Re: History Correction [message #342350 is a reply to message #342348] Fri, 22 August 2008 01:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
s/delete/update/

Regards
Michel
Re: History Correction [message #342353 is a reply to message #342350] Fri, 22 August 2008 02:01 Go to previous messageGo to next message
gauravsunil
Messages: 68
Registered: August 2007
Location: bhubaneswar
Member
Michel, I want your advice on it for whether I go for update in chunk or I take the whole date interval and go for update.

Please suggest me on it.

Regards,
Gaurav
Re: History Correction [message #342360 is a reply to message #342353] Fri, 22 August 2008 02:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please post useful information and complete question.

I say go for update.

Regards
Michel
Re: History Correction [message #342747 is a reply to message #342306] Sun, 24 August 2008 20:31 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
Of the 1 billion rows, how many do you expect to be updating in total?

Kevin
Re: History Correction [message #342772 is a reply to message #342747] Mon, 25 August 2008 01:08 Go to previous messageGo to next message
idris.ali
Messages: 34
Registered: June 2008
Location: Hyderabad
Member
Hi

I think , You may choose a commit size of around 500,000
Use bulk operations in plsql to achieve this.

Thanks,
Idris
Re: History Correction [message #342784 is a reply to message #342772] Mon, 25 August 2008 01:30 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
idris.ali wrote on Mon, 25 August 2008 08:08
Hi

I think , You may choose a commit size of around 500,000
Use bulk operations in plsql to achieve this.

Thanks,
Idris

Why?

Regards
Michel

Previous Topic: DBMS_STATS
Next Topic: Complex Query
Goto Forum:
  


Current Time: Sun Dec 11 03:55:15 CST 2016

Total time taken to generate the page: 0.06667 seconds