Re: RBS and refreshing snapshots
Date: 1996/05/31
Message-ID: <4onetb$djm_at_sjx-ixn6.ix.netcom.com>#1/1
Chuck,
Was this the ONLY rollback segment online? To guarantee a rollback segment is used, you have to use
SET TRANSACTION USE ROLLBACK SEGEMENT <rbs_name> begin dbms_snapshot.refresh('CODE','?','rlrg'); end; COMMIT; Hope this helps.
Steve
oHHop
In <31aef954.4859049_at_news2.ios.com> chuckh_at_dvol.com (Chuck Hamilton)
writes:
>
>Can someone explain why I got an error saying that rbs 'R02' couldn't
>be extended while refreshing a snapshot where I specifically asked for
>rbs 'RLRG'? I've verified that RLRG is ONLINE and nobody else is using
>it.
>
>Message follows:
>
>begin dbms_snapshot.refresh('CODE','?','rlrg'); end;
>
>*
>ERROR at line 1:
>ORA-12008: error in snapshot refresh path
>ORA-01562: failed to extend rollback segment (id = 3)
>ORA-01628: max # extents (20) reached for rollback segment R02
>ORA-06512: at "SYS.DBMS_SNAPSHOT", line 248
>ORA-06512: at "SYS.DBMS_SNAPSHOT", line 131
>ORA-06512: at line 1
>
>--
>Chuck Hamilton
>chuckh_at_dvol.com
>
>Never share a foxhole with anyone braver than yourself!
Received on Fri May 31 1996 - 00:00:00 CEST