Oracle Replication Failed

From: hlk <hlk_at_onetel.net.uk>
Date: Sun, 17 Dec 2000 11:50:18 +0000
Message-ID: <3A3CA87A.A40ABECB@onetel.net.uk>

Hi,

I have two Oracle databases in replication, Oracle replicates 3 tables every night form master1 to slave1. The automatic replication is failed, so I try to rerun it manually with a script : dbms_refresh.resfresh (' "manager"."dbuk01" ')

I get this error message :

###############################################

SVRMGR> begin
     2> dbms_refresh.refresh('"MANAGER"."DBUK01"');
     3> end;
     4> /

ORA-00604: error occurred at recursive SQL level 1 ORA-01632: max # extents (1024) reached in index CSECURE.I_SNAP$_CS_PASSWORD

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 271
ORA-06512: at "SYS.DBMS_IREFRESH", line 416
ORA-06512: at "SYS.DBMS_REFRESH", line 171
ORA-06512: at line 2

SVRMGR>
###############################################
can someone explains me what it means, and how to sort it out. Thanks a lot!

Chris. Received on Sun Dec 17 2000 - 05:50:18 CST