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: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Wed, 15 Sep 2004 22:30:06 +0200
Message-ID: <5g9hk0d7t5llvg09624cf3jlq9ssa31lfk@4ax.com>


On 15 Sep 2004 09:02:04 -0700, gdas1_at_yahoo.com (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?

non-sequitur. You can resize them to 1 block after the deed.

If you don't want sensible advice, why do you post here?

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Sep 15 2004 - 15:30:06 CDT

Original text of this message

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