is there any limitation on using "on prebuilt table" option while creating the materialized view. If I create the materialized view with out this, it is fetching the data, if I use this it is not fetching the data. Can some body explain this.
Long back i had problem droping a oracle user becaz a single snapshot was not getting dropped.
This happened becaz I renamed the table on which snapshot was created and then I dropped the table.
Then snapshot dropping was not taking place saying object does not exist.
My senior dba asked question related to this and u suggested create snapshot with pre buit option whch we implemented
and was successful