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 18.104.22.168 SE1 Test - RHEL 4.0, 32-bit Oracle 22.214.171.124, SE1 Development - RHEL 4.0, 32-bit Oracle 126.96.36.199 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 -- http://www.freelists.org/webpage/oracle-l