By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,225 Members | 1,051 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,225 IT Pros & Developers. It's quick & easy.

Moving tables to new schema

P: n/a
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.

May 1 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
sandeep,

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

regards,

Mehmet

May 1 '06 #2

P: n/a
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.

May 1 '06 #3

P: n/a
"shsandeep" <sa**********@gmail.com> wrote in message
news:bd******************************@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.

May 1 '06 #4

P: n/a
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.
May 1 '06 #5

P: n/a
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
May 1 '06 #6

P: n/a
Viper!!! COME SOON!!
Thanks guys.

Cheers
San.

May 2 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.