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

Actually, I'm afraid this wouldn't work. When you take one datafile of a tablespace offline, the entire tablespace is becomes inaccessible. I can't think of any way to do this. But then, why would you want to?

Regards,

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original music? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult

Demon wrote in message
<935968041.21513.0.nnrp-09.c2de0af6_at_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 - 20:25:03 CDT