create snapshot cause ORA-1650
From: Roger Xu <wellmetus_at_gmail.com>
Date: Thu, 18 Nov 2010 15:54:39 -0600
Message-ID: <AANLkTikzF3vvk1H4LB8sfi9ZNSb7pWzUPCexF+3sAOWx_at_mail.gmail.com>
Hi List,
Date: Thu, 18 Nov 2010 15:54:39 -0600
Message-ID: <AANLkTikzF3vvk1H4LB8sfi9ZNSb7pWzUPCexF+3sAOWx_at_mail.gmail.com>
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_at_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.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 18 2010 - 15:54:39 CST