Re: Help !

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