Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Change Master Rollback segment for a snapshot..MASTER_ROLLBACK_SEG

Change Master Rollback segment for a snapshot..MASTER_ROLLBACK_SEG

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Mon, 15 Aug 2005 20:42:29 GMT
Message-ID: <4300fd02.11119031@localhost>


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 Received on Mon Aug 15 2005 - 15:42:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US