create snapshot cause ORA-1650

From: Roger Xu <>
Date: Thu, 18 Nov 2010 15:54:39 -0600
Message-ID: <>

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?


Roger Xu


local: Oracle 10g Windows 2008 remote: Oracle 9i with rollback segment 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.

Received on Thu Nov 18 2010 - 15:54:39 CST

Original text of this message