DB2数据库表更改表空间

--重命名
rename table T_HELLO to T_HELLO_bak;

--创建建表并指定表空间
CREATE TABLE
    T_HELLO
    (
        ID BIGINT NOT NULL,
        NAME VARCHAR(64),
        BIRTHDAY TIMESTAMP,
        AGE INTEGER,
        PRIORITY VARCHAR(32),
        CONSTRAINT P_KEY_1 PRIMARY KEY (ID)
    ) in dms4k;
--往新表插入旧数据
INSERT INTO T_HELLO (ID, NAME, BIRTHDAY, AGE, PRIORITY)
SELECT ID, NAME, BIRTHDAY, AGE, PRIORITY FROM T_HELLO_bak;

--检查新表没有问题后删除备份表
drop table T_HELLO_bak
--truncate table T_HELLO_bak immediate