Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving tables to a new tablespace?
Alter table emp move tablespace BLAH;
Schema doesn't even come into it: you can never change the schema of an object, unless you export it, drop it, and import it with the FROMUSER/TOUSER parameters.
Regards
HJR
"Tiger Woods" <clintonn_at_meb.co.za> wrote in message
news:3ddc85a2$0$229_at_hades.is.co.za...
> Hi all.
>
> What is the sytax to move a table to a new tablespace within the same
> schema?
>
> Thanks
>
> Clint
>
>
Received on Thu Nov 21 2002 - 01:21:20 CST