Re: Oracle Replication Failed

Hi,

I will try running the following command, but I am not sure about the syntax Can you correct me or provide me the right syntax.

alter index CSECURE.I_SNAP$_CS_PASSWORD default storage (maxextents 2048);

Thanks a lot for your help
Chris

Sybrand Bakker wrote:

> 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 - 13:53:29 CST