| Rollback segments and ORACLE 9.0.2 [message #55647] |
Thu, 06 February 2003 09:41  |
LOCHT
Messages: 2
Registered: February 2003
|
Junior Member |
|
|
I have executed a script performing updates on a big table, into a loop with a COMMIT at each loop.
And I have this message:
ORA-01555 snapshot too old: rollback segment number 10 with name "_SYSSMU10$" too small
I try to create Rollback segments and I have de message:
Rollback segment is successfully created.
After this, I have altered this Rollback segment to ONLINE and I have the message:
Rollback segment is successfully alterd.
When I execute the command:
SELECT segment_name, tablespace_name, status
FROM sys.dba_rollback_segs;
I not see my new Rollback segment and the problem during the script execution still the same:
SEGMENT_NAME TABLESPACE_NAME STATUS
------------------------------ ------------------------------ ----------------
SYSTEM SYSTEM ONLINE
_SYSSMU1$ UNDOTBS ONLINE
_SYSSMU2$ UNDOTBS ONLINE
_SYSSMU3$ UNDOTBS ONLINE
_SYSSMU4$ UNDOTBS ONLINE
_SYSSMU5$ UNDOTBS ONLINE
_SYSSMU6$ UNDOTBS ONLINE
_SYSSMU7$ UNDOTBS ONLINE
_SYSSMU8$ UNDOTBS ONLINE
_SYSSMU9$ UNDOTBS ONLINE
_SYSSMU10$ UNDOTBS ONLINE
Could anyone help me to solve this problem ?
Thank You.
|
|
|
|
|
|
|
|
| Re: Rollback segments and ORACLE 9.0.2 [message #165981 is a reply to message #55649] |
Mon, 03 April 2006 20:13  |
rzmni
Messages: 8
Registered: May 2005
|
Junior Member |
|
|
| Mahesh Rajendran wrote on Thu, 06 February 2003 11:25 |
the database might have been configured with undo tablespace ( automatic undo).
SQL> show parameter UNDO_RETENTION
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_retention integer 10800
this is default ( value is in seconds 10800/60=180 minutes or 3 hours).
increase the value and try again.
you may need to increase the datfiles for the undo tablespace
|
how to increase?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
