Home » SQL & PL/SQL » SQL & PL/SQL » Please hepl me Urgent
icon4.gif  Please hepl me Urgent [message #432290] Mon, 23 November 2009 08:15 Go to next message
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
Re: Please hepl me Urgent [message #432291 is a reply to message #432290] Mon, 23 November 2009 08:19 Go to previous messageGo to next message
pablolee
Messages: 2813
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?
Re: Please help me Urgent [message #432296 is a reply to message #432291] Mon, 23 November 2009 08:33 Go to previous messageGo to next message
plsql_dev
Messages: 3
Registered: November 2009
Junior Member
it's interview question.

It's a scenario based question and it's assumption.
Re: Please help me Urgent [message #432297 is a reply to message #432296] Mon, 23 November 2009 08:35 Go to previous messageGo to next message
pablolee
Messages: 2813
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.
Re: Please hepl me Urgent [message #432302 is a reply to message #432290] Mon, 23 November 2009 08:56 Go to previous messageGo to next message
Bill B
Messages: 1458
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.
Re: Please help me Urgent [message #432330 is a reply to message #432297] Mon, 23 November 2009 10:31 Go to previous messageGo to next message
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.
Re: Please help me Urgent [message #432331 is a reply to message #432330] Mon, 23 November 2009 10:33 Go to previous messageGo to next message
Bill B
Messages: 1458
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.
Re: Please hepl me Urgent [message #432524 is a reply to message #432290] Tue, 24 November 2009 16:20 Go to previous message
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:
  


Current Time: Wed Sep 28 09:15:31 CDT 2016

Total time taken to generate the page: 0.16497 seconds