OraFAQ Forum: SQL & PL/SQL » Please hepl me Urgent

Home » SQL & PL/SQL » SQL & PL/SQL » Please hepl me Urgent

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

Please hepl me Urgent [message #432290]

Mon, 23 November 2009 08:15

plsql_dev
Messages: 3
Registered: November 2009

Junior Member

There are two tables t1 and t2 with ten crores of data. Structure of both tables are same.
DML (Insert,Update,Delete) fires on table t1

1. How to get log details of 24*7 on table t1
2. How to sink up data between two table t1 and t2

Report message to a moderator

Re: Please hepl me Urgent [message #432291 is a reply to message #432290]

Mon, 23 November 2009 08:19

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

1. What does this mean?
2. Why are you storing exactly the same values in two tables?
3. Why is this urgent?

Report message to a moderator

Re: Please help me Urgent [message #432296 is a reply to message #432291]

Mon, 23 November 2009 08:33

plsql_dev
Messages: 3
Registered: November 2009

Junior Member

it's interview question.

It's a scenario based question and it's assumption.

Report message to a moderator

Re: Please help me Urgent [message #432297 is a reply to message #432296]

Mon, 23 November 2009 08:35

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

plsql_dev wrote on Mon, 23 November 2009 14:33

it's interview question.

It's a scenario based question and it's assumption.

Nothing you have said seems to answer my questions.

Report message to a moderator

Re: Please hepl me Urgent [message #432302 is a reply to message #432290]

Mon, 23 November 2009 08:56

Bill B
Messages: 1971
Registered: December 2004

Senior Member

There are a few ways to do this.

1) use triggers to automatically maintain the second table.

2) make the second table a view of the first table.

3) make the second table a synonym of the first table.

4) Make the second table a materialized view of the first table with on commit update.

Report message to a moderator

Re: Please help me Urgent [message #432330 is a reply to message #432297]

Mon, 23 November 2009 10:31

plsql_dev
Messages: 3
Registered: November 2009

Junior Member

1. I need to see all statements executed on t1 table.

Once in a day sync that data from t1 to table t2.

2. It is assume.

Report message to a moderator

Re: Please help me Urgent [message #432331 is a reply to message #432330]

Mon, 23 November 2009 10:33

Bill B
Messages: 1971
Registered: December 2004

Senior Member

1) turn on oracle auditing for table 1.

2) make a materialized view for table 2 with a daily scheduled refresh.

Report message to a moderator

Re: Please hepl me Urgent [message #432524 is a reply to message #432290]

Tue, 24 November 2009 16:20

wakula
Messages: 150
Registered: February 2008
Location: Poland

Senior Member

Maybe we could add some filter to automatically delete/block threads with ANY('URGENT','HELP%PLEASE',...) in the subject ?

Littlefoot wrote at Mon, 27 August 2007 14:34

"Avoid the following keywords: urgent/please/help/now/immediately (and derivatives)" In this thread

[Updated on: Tue, 24 November 2009 16:31]

Report message to a moderator

Previous Topic:	compare
Next Topic:	ORA-00936 coming in execute immediate

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 08 19:42:01 CST 2025