Home » Server Options » Replication » MViews Table (Oracle 10G)
MViews Table [message #336761] Mon, 28 July 2008 22:48 Go to next message
saagar
Messages: 79
Registered: December 2007
Member
Dear all

i have one question on MVIEWS.....

Where the logs will be logged for all the materialized views transactions (I mean a particular table)?

Is there any Data Dictionary Table were i can find this ...

kindly help me to find the view or table in Dictionary tables


CHeers
Re: MViews Table [message #336775 is a reply to message #336761] Mon, 28 July 2008 23:40 Go to previous message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
To fast refresh a materialized view materialized view log is created on the table from which you create a materialized view.
And the transactions are locked in this log table.

Thier are several Data Dictionary views that will give you information regarding mview like user_mview_logs,dba_snapshots

Regards,
Rajat
Previous Topic: what is the difference between materialized view and snapshot
Next Topic: Best practise: Should the Target DB in replication be in archive-log mode?
Goto Forum:
  


Current Time: Fri Mar 29 02:27:15 CDT 2024