create snapshot cause ORA-1650
- From: Roger Xu <wellmetus@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 18 Nov 2010 15:54:39 -0600
Hi List,
Does anyone know why creating/refreshing MViews cause ORA-1650 in the remote
database? Is it because of updatable MView? Is it for MView log changes?
Thanks,
Roger Xu
P.S.
local: Oracle 10g 10.2.0.3.0 Windows 2008
remote: Oracle 9i with rollback segment 9.2.0.7.0 HP-UX
create snapshot foo pctfree 0 pctused 90 refresh fast with rowid for
update
as select whatever from foo@remote_db;
ORA-1650: unable to extend rollback segment R10 by 4096 in tablespace
RBS_TS_01
Failure to extend rollback segment 16 because of 1650 condition
FULL status of rollback segment 16 set.
Other related posts:
- » create snapshot cause ORA-1650 - Roger Xu
