Re: Move Table to another tablespace?

In 9i there is..see the docs for the parameters.. I don't think 8 has it but you can create a clone with: create table table_name tablespace NEWSPACENAME as select * from orig_table;

then drop the original ---

The 'clone' may need to have its permissions,constraints, etc redone..but the data will be there

"Lars Steinmetz" <no_spam_lsteinmetz_at_jakrause.com> wrote:

>Hello NG,
>
>how can I move a table with it's data move to another tablespace? Is there
>an "alter table move" command?
>May someone help me?
>
>Thanx
>
>Greets Lars
>
Received on Thu Feb 06 2003 - 15:54:48 CST