You will have to drop and re-create the objects ...
Workaround is to define aliases for the objects ...
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
Visit the new-look IDUG Website , register to gain access to the excellent content.