Re: Critical Qs on materialized views - Undo Amt Needed ?

Hi Vivek,

Just this morning I am trying to answer nearly the same question. (200 GB is the only difference)

I will share what I find, and hope you do likewise.

Jared

On 8/29/05, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:
>
> Folks
>
> What is the amount of Undo/RBS needed in the Target/Slave Database when
> creating a MV on a approx 100 GB Table using Prebuilt table clause?
>
> Any thumb rules, docs, links?
>
> Thanks indeed
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> solely for the use of the addressee(s). If you are not the intended
> recipient, please notify the sender by e-mail and delete the original
> message. Further, you are not to copy, disclose, or distribute this e-mail
> or its contents to any other person and any such actions are unlawful. This
> e-mail may contain viruses. Infosys has taken every reasonable precaution to
> minimize this risk, but is not liable for any damage you may sustain as a
> result of any virus in this e-mail. You should carry out your own virus
> checks before opening the e-mail or attachment. Infosys reserves the right
> to monitor and review the content of all messages sent to or from this
> e-mail address. Messages sent to or from this e-mail address may be stored
> on the Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l