Re: Move Table to another tablespace?

"Lars Steinmetz" <no_spam_lsteinmetz_at_jakrause.com> wrote in message 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
>
>

There is in 8i and higher
alter table ... move tablespace ...
Note: this command doesn't work for tables with a LONG column.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address