Re: ORA-01552: cannot use system rollback segment for non-system tablespace 'string'

  • From: Peter van Rijn <petervanrijn@xxxxxxxxx>
  • To: sbecker6925@xxxxxxxxx
  • Date: Tue, 13 Nov 2007 22:10:48 +0100

Hi Sandy,
Did you check your database actually has a UNDO-tablespace, and that it is online? Please check DBA_ROLLBACK_SEGS to see if any non-SYSTEM undo segment really exists. 

regards,

Peter


Sandra Becker schreef:

Production - RHEL 4.0,  64-bit Oracle 9.2.0.8 SE1
Test - RHEL 4.0, 32-bit Oracle 9.2.0.5, SE1
Development - RHEL 4.0, 32-bit Oracle 9.2.0.5 EE  (Named user license)

I have a developer trying to do an insert/rollback, in production no
less.  He says it works in his schema in the development database and
the test schema.  Unfortunately, these databases are not the same
releases as production.  The rollback is failing with this error:

ORA-01552:   cannot use system rollback segment for non-system
tablespace 'string'

We are using UNDO not rollback and I verified that the user he is
connecting as has the correct privileges and has an assigned default
and temporary tablespace that is not SYSTEM.  I'm at a loss where to
look for his problem.  Any ideas?  (Other than developers shouldn't be
in production.  Working on that piece with my new boss.)

Sandy
--
//www.freelists.org/webpage/oracle-l




--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2007