Re: Help !

No, No, No

You now have a tablespace.
You need to create a rollback segment in that tablespace (create rollback segment etc)
You need to put that online manually at first (alter rollback segment ... online)
You need to include the NAME of the rollback segment in the init.ora parameter.

Hth,

Sybrand Bakker, Oracle DBA

Echoes <echoes_at_free.fr> wrote in message news:38E4D3E4.43863B37_at_free.fr...
> Juhan Kundla wrote:
> >
> > ORA-01552 cannot use system rollback segment for non-system tablespace
> > 'string'
> >
> > Cause: An attempt was made to use the system rollback segment for
> > operations involving non-system tablespace. If this is a clone database
> > then this will happen when attempting any data modification outside of
> > the system tablespace. Only the system rollback segment can be online in
> > a clone database.
> >
> > Action: Create one or more private/public segment(s), shut down and
> > restart. May need to modify the initialization parameter
> > ROLLBACK_SEGMENTS to acquire private rollback segment. If this is a
> > clone database being used for tablespace point in time recovery then
> > this operation is not allowed.
> >
> > Cheers,
> > Juhan
>
> Thanks for your help, but I think I need a little bit more...
> I created a datafile in the RBS tablespace, and put this line
> in my initCPGN.ora :
>
> rollback_segments = ("/data/oracle/oradata/CPGN/rbs02.dbf")
>
> Now i've got the following error during startup :
> ORA-01534: rollback segment '/DATA/ORACLE/ORADATA/CPGN/RBS0' doesn't
> exist
>
> I guess i have to tell Oracle that my file is identified by an alias
> and write rollback_segments = (alias), but where should I define this
> alias ?
>
> Fabrice
Received on Fri Mar 31 2000 - 00:00:00 CST