Oracle Enterprise Stage - Table Definition

snt_ds · Post by **snt_ds** » Fri Sep 12, 2008 8:09 am

Hi,

We have jobs (in DEV) having Oracle Enterprise stage where in the columns have a value for the Table Defintion Reference pointing to the corresponding metadata residing in the Repository.

When we deploy such jobs to the UAT Environment, do we need to export the metadata as well or only the job designs will be enough
OR
Should we manually delete the table definition reference details from the stage for each column before the deploy to UAT

Will we get any warnings/error for Not doing either of the above?

We don't intend to use Metastage or do Uasge Analysis in UAT?

Regards,
NV

ray.wurlod · Post by **ray.wurlod** » Fri Sep 12, 2008 5:32 pm

If you follow the standard software development life cycle (that is, changes are only ever made in the development environment) then you don't need to migrate table definitions.

snt_ds · Post by **snt_ds** » Tue Sep 16, 2008 1:07 pm

Yes u are right Ray..

My question is, Is it Ok if we dont manually delete the table definition reference details from the stage for each column..and let it pass along with the job during UAT deploy?

ray.wurlod · Post by **ray.wurlod** » Tue Sep 16, 2008 3:10 pm

What do you mean by OK? If you mean "will the jobs still work" then the answer is "yes". If you mean "can I do accurate Usage Analysis in the new environment" then the answer is "probably not" but you can effect the Usage Analysis in the original environment.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 16, 2008 3:11 pm

DSXchange is not a mobile phone. Please don't use SMS-style abbreviations. The second person personal pronoun is spelled "you" in English, not "u". I personally find "u" offensive.