OraFAQ Forum: Server Administration » table data difference

Home » RDBMS Server » Server Administration » table data difference (Oracl1 10.2.0.3 , HP-UX itanium)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

table data difference [message #509154]

Thu, 26 May 2011 05:42

seema.taunk
Messages: 96
Registered: October 2006

Member

Hi,

We want to find out difference of data for some tables beween current day & previous day. We can use query with minus operation but it will take lot of time since table size is in range from 200 to 500 GB.
We have to do this exercise every day.
Is there any other method to do this?

Thanks & regards,
Seema

Report message to a moderator

Re: table data difference [message #509159 is a reply to message #509154]

Thu, 26 May 2011 05:53

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

http://www.oracle-base.com/articles/10g/Flashback10g.php
Quote:

We can use query with minus operation

I doubt it ....

[Updated on: Thu, 26 May 2011 05:55]

Report message to a moderator

Re: table data difference [message #509160 is a reply to message #509159]

Thu, 26 May 2011 05:57

seema.taunk
Messages: 96
Registered: October 2006

Member

Thanks. But we have to find out what insertions,updations & deletions took place on particular table?

[Updated on: Thu, 26 May 2011 06:36]

Report message to a moderator

Re: table data difference [message #509163 is a reply to message #509160]

Thu, 26 May 2011 06:03

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

You should read about "FLASHBACK TECHNOLOGY" More and more
Have a look at transaction query and version query ...Good luck
Sriram

Report message to a moderator

Re: table data difference [message #509166 is a reply to message #509154]

Thu, 26 May 2011 06:19

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As it is a recurrent issue, you should activate audit on these tables then you will have the information directly in the audit table.

About flashback, if you have so much transactions, I doubt you will have 24 hours of data in the undo tablespace.
If you upgrade in 11.2 you can use flashback archive for this.

Regards
Michel

Report message to a moderator

Re: table data difference [message #509169 is a reply to message #509160]

Thu, 26 May 2011 06:28

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

seema.taunk wrote on Thu, 26 May 2011 11:57

Thanks. But we have to find out how many insertions,updations & deletions takes place in particular table in one day.

Flashback allows you to see what state the data is in at a particular point in time. You're going to find it very difficult to work out the number of DML statements from that.
As Michel says - use audit.

Report message to a moderator

Previous Topic:	Errors while starting the DB using SPfile
Next Topic:	ORA-01034 while running dbca (5 threads merged by bb)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 06:45:26 CST 2024