Re: QUESTION - Standby database under 8i - expected behavior in read only mode

Perhaps. From a 9iR2 system:

$ oerr ora 1552
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.

jg

--
@home.com is bogus.
http://ww.uniontrib.com/news/mexico/tijuana/20060519-9999-1n19border.html
http://www.signonsandiego.com/uniontrib/20060519/news_1n19bush.html