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

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)
>
> I have found how to reset this for snapshot groups (via dbms_refresh
> package) But there is nothing like it in dbms_snapshot package. The
> 'client' database is 8i (client, meaning the one containing the
> snapshots, not the master site)
>
> Any idea how to set it to null?
>
> Thanks!
> .......
> We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes
> remove NSPAM to email

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

HTH
Anurag Received on Mon Aug 15 2005 - 18:36:32 CDT