Re: Moving a table from one tablespace to another tablespace
From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 15 Dec 2003 12:16:03 -0800
Message-ID: <3722db.0312151216.71fb853f_at_posting.google.com>
Date: 15 Dec 2003 12:16:03 -0800
Message-ID: <3722db.0312151216.71fb853f_at_posting.google.com>
The answer is highly dependant on your version. If you have 8i at least, just do "alter table yourtablename move (online) tablespace newtablespace". Look in the SQL reference manual for all the options you can use while doing this move.
Daniel
> Hi NG
>
> what is the easiest way to move a table from one tablespace to another ?
>
> Thanks
> Peter
>
> --
Received on Mon Dec 15 2003 - 21:16:03 CET