Hello World. This is my First of First Blog. Here I will try to write things related to what I learn, Since I am kinda obsessed with Technology’s lineage. I, being a Java professional, love Java profoundly and so tried to make a blog that will help you and me of course to be in touch with new happenings in the field of technology. I may soon start a discussion forum based on Java, for that we need to wait a while, after all , not always, good things are FREE….
To know the materialized view refresh status along with their refresh time, you can issue following query to the database.
SELECT mview_name, refresh_mode, refresh_method, last_refresh_type, last_refresh_date FROM user_mviews;
Also to know the materialized view logs present in schema of a user, use this query
SELECT log_owner, master, log_table FROM user_mview_logs;
Posted by Unknown at 11:18 PM
Labels: Materialized View, Refresh Status
Posts
1 comments:
Your blog keeps getting better and better! Your older articles are not as good as newer ones you have a lot more creativity and originality now keep it up!
Post a Comment