Re: Moving table segment from one datafile to another

Hi Doug.

First, a couple of things:

1. The table IS the segment
2. If you have extents of the table in one datafile that you want to move to another datafile then you can run either:
3. create table <x> as select * from <y> tablespace <new>
4. export/import

it's not possible to move a single extent from one datafile to another (although it would be nice :)
but, it IS possible to manually stripe the extents into certain datafile for a table during the create (or alter) table process before doing an import.

HTH, Dave Haas

"Doug Murphy" <douglasmurphy_at_avaya.com> wrote in message news:91vsb6$1kq_at_nntpa.cb.lucent.com...
> Is there a way to move a segment of a table from one datafile to
 another
> without reorganizing the table or the tablespace? We have a huge (~160
 GB)
> tablespace where the only thing in some datafiles are segments of our
> largest (~20 GB) table, and we want to drop a few datafiles from the
> tablespace to be reused elsewhere without having to reorganize the table.
>
> We are running Oracle 8.0.6 on HP-UX 11.0, if that makes a difference.
> Please contact me directly, in addition to the mail list.
>
> Doug Murphy
> douglasmurphy_at_avaya.com
>
>
>
Received on Fri Dec 22 2000 - 11:32:34 CST