ORA 1562 Rollback segment problem

From: Parris Geiser <parris_at_walleye.esp.bellcore.com>
Date: 1995/05/01
Message-ID: <3o34eb$3ds_at_athos.cc.bellcore.com>#1/1


Hi,

	I have defined the table space for Rollback segments to a size
	of 4M. Our Product Test folks running a particularly large transaction,
	got ORA 1562. The transaction sometimes works and sometimes doesn't.
	In looking at the four segment sizes:
		RB1 532K
		RB2 665K
		RB3 2.5M
		RB4 400K
	Can anyone have a clue as to why the transaction sometimes fails?
	4M seems like it should be enough space. Given that I'm in the
	situation, what is the best way now to get out?

	HP-UX with Oracle 7.0.16.4

	Thanks.
Received on Mon May 01 1995 - 00:00:00 CEST

Original text of this message