-
Hi,
I have set to use a bigger rollback segment call
REI_DATA_LOAD by giving
set transaction use rollback segment rei_data_load.
and I have put a query to get the number of records from the table from which the data is being deleted at background.
I get this err:
ORA-1555: snapshot too old: rollback segment number 5 with name 'RBS4'....too small
But with my setting I am using a bigger RBS while the error shows as a diff one
Can any of you explain.
Badrinath;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|