Re: Move Table to another tablespace?

From: Hans Klassen <h.klassen_at_gmx.de>
Date: Thu, 6 Feb 2003 23:40:24 +0100
Message-ID: <b1uo3d$17fp$1@innferno.news.tiscali.de>

Hi Lars,

Sybrand said it alreay there is a command to move the tables, ALTER TABLE test MOVE TABLESPACE tablespacename;.
But attention. The Indezes of this Table will be INVALID. You must rebuild the indezes of removed table.

Hans

"Lars Steinmetz" <no_spam_lsteinmetz_at_jakrause.com> schrieb im Newsbeitrag news:b1uihe$17l65v$1_at_ID-97972.news.dfncis.de...
> Hello NG,
>
> how can I move a table with it's data move to another tablespace? Is there
> an "alter table move" command?
> May someone help me?
>
> Thanx
>
> Greets Lars
>
>
Received on Thu Feb 06 2003 - 16:40:24 CST