Re: move all tables & data into another tablespace

From: <stephen.howard_at_us.pwcglobal.com>
Date: 9 Dec 2004 09:31:13 -0800
Message-ID: <1102613473.673863.72160@f14g2000cwb.googlegroups.com>

sleepee wrote:
> hi, i'm a newbie ...
>
> I need someone explain me how to move tables &data from a tablespace
to another
>
> my config Oracle 9.i / solaris
>
>
> I have 43 tables includings data in a tablespace TS_AFF_DATA -->
owner AFF01
>
> I want to move them into a new Tablespace TS_UNIC --> owner AFF_UNIC
>
>
> The alter table Move tablespace seems to be a source of error ...
> the best solutions should be an export / import method ....
>
> what are all the step for an export/import good job ....
>
>
> Thx a lot !!!!

This always cracks me up. You pose a question and answer in the same post. Why even bother asking if you already "know" the "solution"? Received on Thu Dec 09 2004 - 11:31:13 CST