what is the size of mview , if not too big

1) drop the mview from the destination
2) drop mview log on source
3) create mview log on source again
4) create mview on destination again

Parveen


Mir Aijaz A wrote:
> hi all,
> please check what could be the problem as i have been reported with wht
> following error
>
> Ora-1234 materialized view log on TBLVIEW is younger than last refresh
> ....
> this is imporat and urgent i am in stress ....
> i can see so many pages of docs but could not understand ...
>
> please help
>
> Thanks and Regards,
> Aijaz
>
>
>
> DISCLAIMER:
> Notice : This e-mail and any attachments may contain information which is confidential to the addressee and may also be privileged. If you are not the intended recipient of this e-mail, you may not copy, forward, disclose or otherwise use it in any way whatsoever. If you have received this e-mail by mistake, please e-mail the sender by replying to this message, and deleting the original and any printout thereof.
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>


Oracle LazyDBA home page