How can I move a table from a schema to another one?

[stajune]

Is it possible? Thanks!

Carmelo

[Dinesh]

1.Use db2look to extract table DDL and then use export and load
command to migrate the table data into the new schema

2. Else just create a Alias in new schema which will poin the
original table .

[Dinesh]

1.Use db2look to extract table DDL and then use export and load
command to migrate the table data into the new schema

2. Else just create a Alias in new schema which will poin the
original table .

[Bohne]

I think I'd do it like that:

Create new table in new schema:
db2 create table <sch2>.<tab> like <sch1>.<tab>

Copy data:
db2 insert into <sch2>.<tab> select * from <sch1>.<tab>

Drop old table:
db2 drop <sch1>.<tab>

Recreate Constraints, Indexes, etc, from original table:
I would do that via a db2look output