From: Terry Ball <terry_ball@csgsystems.com>
Subject: Re: help
Date: 1999/01/15
Message-ID: <369F532F.556C863@csgsystems.com>#1/1
Content-Transfer-Encoding: 7bit
References: <369E10D6.F7860282@emrx.com>
Content-Type: text/plain; charset=us-ascii
Organization: CSG Systems
Mime-Version: 1.0
Newsgroups: comp.databases.oracle.misc


Does the database have any rollback segments on-line besides
the system roolback segment?  From the error message, it sounds
like you need to create and/or bring on-line at least one more
rollback segment.


Terry Ball
Sr. DBA, CSG Systems


John Liu wrote:

> When I tried to insert values into a table, I got the
> following error:
>
> ORA-01552: cannot use system rollback segment for
> non-system tablespace 'T_accesscpa'.
>
> 'T_accesscpa ' is tablespace created by user 'accesscpa'.
>
> Thanks very much!
>
> John Liu