Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 300
  • Last Modified:

materilized log

actually where is materialized view log is located...
0
walkerdba
Asked:
walkerdba
1 Solution
 
slightwv (䄆 Netminder) Commented:
check the docs:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_6003.htm#SQLRF01303

A materialized view log is located in the master database in the same schema as the master table.
0
 
ajexpertCommented:
Do you want to view the materialized view log?  It is nothing but a table associated with the master table of a materialized view.

Check these links:

http://www.sqlsnippets.com/en/topic-12878.html


http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_6003.htm
0
 
walkerdbaAuthor Commented:
yes
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now