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.

sandeep,

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

regards,

Mehmet

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.

"shsandeep" <sandeeprshah@gmail.com> wrote in message
news:bd2d697302a179665d6dfe0e288684ad@localhost.ta lkaboutdatabases.com...
> 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.

shsandeep wrote:
> 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.
>
>
Would creating an alias for your two-part name help? Have a look at the
create alias statement.

shsandeep wrote:
> 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
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Viper!!! COME SOON!!
Thanks guys.

Cheers
San.