RE: ORA-01552: cannot use system rollback segment for non-system tablespace 'string'
- From: "Taylor, Chris David" <Chris.Taylor@xxxxxxxxxxxxxxx>
- To: <sbecker6925@xxxxxxxxx>
- Date: Tue, 13 Nov 2007 15:27:28 -0600
Just off the cuff here, but does the application code perform a "SET
TRANSACTION USE ROLLBACK SEGMENT" statement? I can't remember the error
that returns off hand.
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@xxxxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Peter van Rijn
Sent: Tuesday, November 13, 2007 3:11 PM
To: sbecker6925@xxxxxxxxx
Cc: oracle-l
Subject: Re: ORA-01552: cannot use system rollback segment for
non-system tablespace 'string'
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
