Sudhanshu Kumar Yadav (SudhanshuY)
Labb Consulting
Lead System Architect
Labb Consulting
SudhanshuY Member since 2013 15 posts
Labb Consulting
Posted: August 3, 2017
Last activity: August 9, 2017
Posted: 3 Aug 2017 8:53 EDT
Last activity: 9 Aug 2017 12:23 EDT

Regarding Data Schema Upgrade


We have already upgrade our Dev environment successfully(using appendix C approach of upgrade guide) and now we are planning to upgrade our SIT environment, so for this we are doing below high level steps:

1. Creating two blank schema one for Data and one for Rule

2. Upgrading rule schema using data pump method we are importing already upgraded complete rule schema from the Dev environment to SIT environment.

3. For Data schema we are creating all the object(tables, view, function etc) from the meta data of Dev(which is already upgarded) and afterward populating the tables again using data pump method from old schema of SIT environment to this new data schema.

So now my question as we are creating the object by getting the DDL from already upgraded dev environment, so do we need to run the in the SIT environment again, as per me we only need to run this if this scripts is doing any DML operation. So is this is doing any DML operation?

***Updated by moderator: Lochan to add Categories***

System Administration Upgrades
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.