Live company(100) with oracle 8.0 in server A
Archive company(999) with oracle 8.0 in Server B

Operating System for both the server - windows 2000

During Archiving we are getting the error of 1562, we have added datafiles RBS2BAAN.ora with 250 MB size to RBS Roll back tablespace, still we are getting the same error 1562. So we extend the size of existing datafiles RBS1BAAN.ora with 500 MB.

Again we are landing up with same error after processing few records say 30000.

Could anyone suggest to overcome this error.

Hi Senthil,

Are you getting any other Oracle errors?

Try re-creating your RBS tablespace and rollback segments.

For the Rollback Segments, remember to:

* Set the initial extent size equal to the next extent size
* Set optimal size
* Set pctincrease=0

Then re-run your processing. Monitor rollback segment activity using view dba_rollback_segs and v$rollstat - add more space if the rollback segments grow to their maximum size.

James

Dear James..

Its working fine now... thanks

Could you tell us the steps taken to fix it? And where the exact problem was found? Thats always helpful for the next person who experiences the same problem. Searching the board will then be enough to fix it!