Re: copying a large table

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 16 Sep 2004 07:39:38 +1000
Message-ID: <4148b696$0$11308$afc38c87@news.optusnet.com.au>

gdas wrote:

> you can't de-allocate the datafiles you needed to add to enlarge the
> rollback tablespace. For a one-time job, I'm not doing it.

So why not create a completely new tablespace, create a new, huge rollback segment in there, and then drop the tablespace completely after your one-time job?

You are not compelled to have all rollback segments in a single tablespace, after all...

HJR
>
> Anyone care to offer any help?
Received on Wed Sep 15 2004 - 16:39:38 CDT