Re: TableSpace Question

Thanks.

"Brent" <bpathakis_at_yahoo.com> wrote in message news: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 - 16:38:15 CET