Re: Move a object to another data file of the same tablespace

From: Demon <george_at_onest.demon.co.uk>
Date: Mon, 30 Aug 1999 00:08:16 +0100
Message-ID: <935968041.21513.0.nnrp-09.c2de0af6@news.demon.co.uk>

I've never had reason to try this, but I would think it would be possible by exporting the table, dropping it, taking all other datafiles but the one you want offline, then doing the import before bringing the other datafiles online.

Of course you'd need to pay the usual attention to constraints and triggers on the table.

If you do this test it first.

George Harding
KC wrote in message <37C934D1.4A3004F_at_poboxes.com>...
>Dear all,
>
>Is it possible to move a table to a new datafile on the same tablespace
>after addition of new datafiles?
>
>Thanks,
>Kevin Cheung
>
Received on Sun Aug 29 1999 - 18:08:16 CDT