Re: copying a large table

gdas1_at_yahoo.com (gdas) wrote in message news:<7a4ed455.0409150802.7392285e_at_posting.google.com>...
> 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?

Create a new datafile with the big size, create the big rbs, do your thing, drop rbs, shrink datafile.

jg

--
@home.com is bogus.
I told you I wasn't worried.