Re: way to move a table to a new tablespace?

Ian Warshak wrote:
>
> this sounds simple, but i have looked everywhere and cant figure out how to
> move a table to a new tablespace. i'd appreciate some advice if you all dont
> mind..
>
> also - i have used mysql and there is a command to change databases, which i
> think is roughly equivalent to changin tablespaces. is there a way that i
> can effectively change my current tablespace to a different to so i can work
> on some different tables without having to reference them by
> tablespace.table? (say for example i have tables in 2 tablespaces)
>
> thanks again
> ian

alter table XXX move tablespace NEW_TS;

(available from 8i onwards)

before that, its export/import time or equivalent.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse