Re: cannot use system rollback segment for non-system tablespace

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Wed, 20 Dec 2000 13:10:12 -0500
Message-Id: <10716.125016@fatcity.com>

have u read the docs for a 1552 message, its pretty self-explanatory.

but since its the holiday season, i wont be an a$$(yes its a change of pace for me),

01552, 00000, "cannot use system rollback segment for non-system tablespace '%s'"
// *Cause: Tried 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), shutdown and then

//	   startup again. May need to modify the INIT.ORA parameter
//	   rollback_segments to acquire private rollback segment. If this is


//         a clone database being used for tablspace point in time

recovery


//         then this operation is not allowed.

-- 
Joe Testa  http://www.oracle-dba.com
No you can't fix an ORA-600 error, call Oracle Support.

Received on Wed Dec 20 2000 - 12:10:12 CST