| MViews Table [message #336761] |
Mon, 28 July 2008 22:48  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
