Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Moving tables to another tablespace

Re: Moving tables to another tablespace

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 22 Mar 2001 18:50:43 +0100
Message-ID: <tbkf0oggkloc2c@beta-news.demon.nl>

"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.
>
>
>

The short algorithm for this is
- take the sql reference manual
- look up alter table ... move

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Mar 22 2001 - 11:50:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US