Re: Change Master Rollback segment for a snapshot..MASTER_ROLLBACK_SEG

On Mon, 15 Aug 2005 23:36:32 GMT, Anurag Varma <avdbi_at_hotmail.com> wrote:

>NetComrade wrote:
>> All,
>>
>> We have a couple of snapshots that had the rollback segment defined.
>> As we have upgraded the 'master' database to 9i, we've gone the
>> 'automatic undo' way.. Although we have the undo_suppress_errors set
>> to true, it doesn't seem to work with snapshots (aka materialized
>> views)
>>

...
>
>Try:
>alter materialized view <mviewname> refresh
>using default master rollback segment;
>

Perfect.. thanks!
.......
We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4 remove NSPAM to email Received on Tue Aug 16 2005 - 10:02:25 CDT