Application Root Objects Conversion for Existing Objects

2.2.7 Application Root Objects Conversion for Existing Objects

Various Sharing types of objects during installation:

A static table will hold the information of selected table sharing as Data link. Other tables will be treated as Meta Data Link
Sharing of object types such as INDEX, LOB, TABLE PARTITION, SEQUENCE, and DYNAMIC PACKAGES will remain as NONE.
All other object types such as Packages, Procedures, Functions, and Synonyms would be converted as Meta Data Link sharing.

Sharing during upgrade:

Sharing of existing database objects will remain the same.

Below script takes care of converting the modified MDL objects when there is a re-creation [objects with Create or Replace command during creation] happens during patch-set.

07_Object_Conversion.sql

Input sample for the script:

Table 2-4 Input sample for the script:

Spool Path	<< Any local path>>
Application next version	14.4.0.0.0

When there are new tables introduced as part of patch-set which has to be converted into DL will be done separately. The recommendation for the same will be provided as part of patch-set instructions for this case.

Parent topic: Steps to be Followed