D
Dmitry Duginov
I was trying to create a new Oracle database using the existing one a a
start point.
User1 is the owner of the existing tables in Database1. I reverse-engineered
it, make some changes (add/remove columns). Then I generated the script,
logged as User2 to the Database2 (on the different server!) and created the
new table structure.
Now I have a problem. The model remembers "User1" as the owner of the
original tables and wouldn't allow me to change the owner. Because of that
Visio doesn't recognize that my new tables from the model already exist and
refresh model/update database functions are screwed up.
Any suggestions?
start point.
User1 is the owner of the existing tables in Database1. I reverse-engineered
it, make some changes (add/remove columns). Then I generated the script,
logged as User2 to the Database2 (on the different server!) and created the
new table structure.
Now I have a problem. The model remembers "User1" as the owner of the
original tables and wouldn't allow me to change the owner. Because of that
Visio doesn't recognize that my new tables from the model already exist and
refresh model/update database functions are screwed up.
Any suggestions?