Re: Rollback segment question!!!

From: <markp7832_at_my-deja.com>
Date: Tue, 26 Oct 1999 14:01:49 GMT
Message-ID: <7v4c8b$1jp$1@nnrp1.deja.com>

In article <7v46lb$t67$1_at_nnrp1.deja.com>, david_petit_at_yahoo.com wrote:
> Hello all,
>
> I want to insert large amount of data to Oracle table by using SQL
> statmenet (one copy SQL statment). However, I find that the rollback
> segment is not large enough. I want to create another rollback segment
> (large size), do the transaction, then drop the rollback segment. Is
it
> possible? If yes, how can I do that? (I don't want to increase the
size
> of existing rollback segment)
>

Yes, you can create a special large rollback segment, use it for your one-time task, and then drop it if you use the 'set transaction use rollback segment seg_name ;' command to direct your session to make use of it.

I hope your use of the sigular in your last sentence was an oversite!

--
Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 26 1999 - 09:01:49 CDT