Re: Critical Qs on materialized views - Undo Amt Needed ?
- From: Jared Still <jkstill@xxxxxxxxx>
- To: VIVEK_SHARMA@xxxxxxxxxxx
- Date: Mon, 29 Aug 2005 09:23:55 -0700
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@xxxxxxxxxxx> 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
Other related posts:
