Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migrate from UAT database to Production database

416967Oct 17 2004 — edited Oct 19 2004

Hi all,

I need to set up my production database based on the UAT database.I would like to re-generate all my objects script and grant scripts from UAT so that there will not be any discripency. I can't go for full db export due to some apps constraints.I'm planing to generate grant scripts from dba_tab_privs for each role and generate public synonym script from dba_objects for each user.Object inventory can be taken from dba_objects for each user. FK and PK constraints are another worry.
Am I on a right path?? My worry is that, I may miss out something. Can anyone guide me?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 16 2004

Added on Oct 17 2004

#general-database-discussions

15 comments

1,632 views