Which DB my mview resides???

Today one of my friend called me and asked - Can we determine the database and the mview, from the database where mview log resides? The mview log was occupying lot of space which he wanted to drop and recreate, which was followed by complete refresh of mview (which used that mview log).He had no … Continue reading Which DB my mview resides???