materilized log

actually where is materialized view log is located...
walkerdbaAsked:
Who is Participating?
 
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
 
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
 
walkerdbaAuthor Commented:
yes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.