Re: Oracle Replication Failed

Remove 'default' that's for tablespaces, not for individual objects.

Regards,

Sybrand Bakker, Oracle DBA

"hlk" <hlk_at_onetel.net.uk> wrote in message news:3A3D19B9.3E1B6AD2_at_onetel.net.uk...
> 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 - 15:35:04 CST