Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: copying a large table

Re: copying a large table

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 15 Sep 2004 20:52:05 -0700
Message-ID: <1095306794.1711@yasure>


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.
>
> Anyone care to offer any help?

You can if you use UNDO rather than rollback.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Wed Sep 15 2004 - 22:52:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US