Re: Moving tables to another tablespace

From: bgbgbg <brian.gallagher_at_iona.com>
Date: Thu, 22 Mar 2001 14:24:27 -0000
Message-ID: <99d2d2$fjn$1@spider.iona.com>

alter table tablea move tablespace data02;

from the DD point of view table is never gone.

hth

rgds
brian

"PasirRis" <jackling_at_singnet.com.sg> wrote in message news:99d0ru$ivk$1_at_dahlia.singnet.com.sg...
> version: Oracle Std Ed 8.1.7 on Sun Solaris 8.
>
> hv 2 tablespaces for user data, e.g. DATA01 & DATA02.
>
> The default tablespace of user X was accidentally put as DATA01 (which I
> don't want).
> And user X has created a lot of tables in the schema. Live data is in
also.
>
> Then, realize that (for some reasons) I should hv kept the tables to
DATA02.
>
> Can I do that? And what is the command / procedures to do that?
>
> thanks in advance.
> jackling.
>
>
>
Received on Thu Mar 22 2001 - 08:24:27 CST