Hi Guys,

Just wondering whether is anyone have heard or know of a new db2 command equivalent to the 'alter table move' existing in Oracle. I need to move a bunch of tables to a new tablespace and I know that since DB2 8.2 became available it has a lot of new goodies so I'm hoping we have something new able to help me. Otherwise I will have to stick with export/import approach.

Cheers,

harby.

i dont think so,
u have to apply same old approach export/import :-(

You should be able to use the ALTOBJ stored procedure to change the tablespace for a table.

Andy

Yet another alternative:

1. RENAME TABLE
2. CREATE TABLE ... LIKE <renamed-table>
3. INSERT INTO ... SELECT * FROM <renamed-table>
4. DROP <renamed-table>

You will have to take care of constraints, however.

A problem may be that the INSERT will be logged. You can use NOT LOGGED INITIALLY in that case, or export/load (import will be logged, too!)

There's also a load from cursor, which should be a bit faster than messing with files.