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,

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-l
Received on Thu Nov 18 2010 - 15:54:39 CST

Original text of this message