Re: Oracle Replication Failed

Looks obvious enough,
there is an index
CSECURE.I_SNAP$_CS_PASSWORD
which has reached it maxextents, which has been set at 1024. Either change the maxextents of this index to unlimited, or rebuild the index with a bigger initial and/or next extent.

Regards,

Sybrand Bakker, Oracle DBA

"hlk" <hlk_at_onetel.net.uk> wrote in message news:3A3CA87A.A40ABECB_at_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 - 07:08:43 CST