Re: RollBack TableSpaces
From: GreekYupie <greekyupie_at_aol.com>
Date: 1996/08/23
Message-ID: <4vlss7$hkq_at_newsbf02.news.aol.com>#1/1
Date: 1996/08/23
Message-ID: <4vlss7$hkq_at_newsbf02.news.aol.com>#1/1
Rollback usage is controlled by the database. You can say for example
SET TRANSACTION USE ROLLBACK SEGMENT XXXX; This will allow transactions to use a specific rollback segment.
To specify which tablespace to use, allocate the rollback segments in the desired tablespace, and activate them in the INIT.ORA file of the database. You can also use ALTER ROLLBACK SEGMENT XXXX ONLINE; to accomplish the same thing immediately. Received on Fri Aug 23 1996 - 00:00:00 CEST