Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to move objects from one datafile to another?
Eugene wrote:
> On Mar 1, 9:43 am, Brian Peasland <d..._at_nospam.peasland.net> wrote:
> > Thanks Brian for your reply, > Actually, ALTER TABLE MOVE is available in 8.1.6. I've used it a > couple of times. > How would I do it using this option? > > Eugene >
I couldn't remember which version the ALTER TABLE MOVE command first appeared in. My quick glance at the 8i docs did not show it...maybe I looked too fast. But that's why I gave the other option. In any case, it is probably easiest to move the data into that tablespace with this command, so long as the table does not contain a LONG or LONG RAW column. You can move tables as follows:
ALTER TABLE table_name MOVE TABLESPACE new_ts;
Similarly, you can move indexes too:
ALTER INDEX index_name REBUILD TABLESPACE new_ts;
HTH,
Brian
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - Unknown -- Posted via a free Usenet account from http://www.teranews.comReceived on Thu Mar 01 2007 - 12:41:28 CST
![]() |
![]() |