Changing the Schema name

quigleyd · #1 (**permalink**) 11-17-03, 11:58

We currently have database 1 setup with schema name aa, when we copy it back to database 2, it still has the same schema name, How can we change it, so database 2 would have a schema bb.

This is on DB2 v8 Fixpak 3, Aix 5.2

sathyaram_s · #2 (**permalink**) 11-17-03, 12:12

Not possible, AFAIK ...

You will have to drop and re-create the objects ...

Workaround is to define aliases for the objects ...

Cheers
Sathyaram

Quote:

Originally posted by quigleyd
We currently have database 1 setup with schema name aa, when we copy it back to database 2, it still has the same schema name, How can we change it, so database 2 would have a schema bb.

This is on DB2 v8 Fixpak 3, Aix 5.2

Internet Services

Web Development

Digital Marketing

Consumer Tech