Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help

Re: help

From: Terry Ball <terry_ball_at_csgsystems.com>
Date: 1999/01/15
Message-ID: <369F532F.556C863@csgsystems.com>#1/1

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
Received on Fri Jan 15 1999 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US