Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Change Master Rollback segment for a snapshot..MASTER_ROLLBACK_SEG
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
![]() |
![]() |