sandip wrote:
> Hi,
>
> i need to change the tablespace of a table, ie. use another tablespace
> for the table and stop the use of the existing tablespace. Is there any
> way i can accomplish this? One solution might be export the data from
> the table, re-create the tables in the new tablespace, drop the
> original tablespace and load the data. But i would prefer another
> simple and less time-consuming way.
>
> Any suggestions would be highly appreciated.
>
> Thanks in advance,
> Sandip.
>
You can do a "load from cursor". One way or another the data needs to move.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab