Moving tables to new schema

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shsandeep - 01 May 2006 04:21 GMT

I currently have 500 tables in 1 single schema.
I would like to move 250 out of the 500 tables into a new schema.
How is this done?
Thanks.

Reply to this Message

Mehmet Baserdem - 01 May 2006 05:01 GMT

sandeep,

If I'm not wrong, unfortunately you need to export & import those 250
tables.

regards,

Mehmet

Reply to this Message

shsandeep - 01 May 2006 05:54 GMT

But isn't it true that schema is just a logical grouping of data objects?
Why do I then physically need to move the entire data alongwith it?

Cheers,
San.

Reply to this Message

Mark A - 01 May 2006 06:07 GMT

> But isn't it true that schema is just a logical grouping of data objects?
> Why do I then physically need to move the entire data alongwith it?
>
> Cheers,
> San.

In DB2 you can rename the table name, but not the schema name. Just accept
it and move on with your life.

Reply to this Message

Bob [IBM] - 01 May 2006 06:12 GMT

> But isn't it true that schema is just a logical grouping of data objects?
> Why do I then physically need to move the entire data alongwith it?
[quoted text clipped - 3 lines]
>
>

Would creating an alias for your two-part name help? Have a look at the
create alias statement.

Reply to this Message

Serge Rielau - 01 May 2006 12:43 GMT

> But isn't it true that schema is just a logical grouping of data objects?

Correct.

> Why do I then physically need to move the entire data alongwith it?

Rename simply hasn't gotten as much attention as it could have.
No technical reason at all.
Note that in DB2 Viper ALTER TABLE ALTER COLUMN has received a lot of
attention which has been much more common requirement.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

shsandeep - 02 May 2006 02:56 GMT

Viper!!! COME SOON!!
Thanks guys.

Cheers
San.

Reply to this Message