Re: TableSpace Question

From: Brent <bpathakis_at_yahoo.com>
Date: 6 Feb 2003 20:58:32 -0800
Message-ID: <1736c3ae.0302062058.68a80dcd_at_posting.google.com>


"Rob Panosh" <rob_panosh_at_asdsoftware.com> wrote in message news:<3e42d182$1_at_nntp01.splitrock.net>...
> Hello,
>
> If I have a table that is in let say TableSpace "Test" and I want to change
> it to be in TableSpace "Production" can this be done using an Alter Table
> statement? Or do I have to create the table and move the data manually?
> Also can any of the Physical Options ( tablespace, extents, storage, ... )
> be changed using an Alter Table Statement?
>
> If it can be done using an Alter Table statement could somebody please give
> me an example?
>
> Thanks,
> Rob Panosh

Depends on your version (i think its 8.1.6 +):

     alter table my_table move tablespace test; Received on Fri Feb 07 2003 - 05:58:32 CET

Original text of this message