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 a new tablespace?

Re: Moving tables to a new tablespace?

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 21 Nov 2002 18:21:20 +1100
Message-ID: <nH%C9.80960$g9.228062@newsfeeds.bigpond.com>


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

Original text of this message

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