Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: copying a large table
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 DBAReceived on Wed Sep 15 2004 - 15:30:06 CDT