DBMS_REPCAT_INSTANTIATE.INSTANTIATE_ONLINE Generates Objects Out of Order
(Doc ID 413880.1)
Last updated on JUNE 05, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.
When creating Replication Deployment templates using DBMS_REPCAT_RGT APIs, the resulting script is generated out of order when called by DBMS_REPCAT_INSTANTIATE.INSTANTIATE_ONLINE, so the object being deployed will fail or become invalid (depending on the object) during remote creation.
1. Suppose you are using a database view and a PL/SQL Package / Package body at your deployment script.
2. The view is using the PL/SQL package so the PL/SQL package must be created before the view.
3. When adding these two objects (view and package) in the deployment template, the view is always created before the package.
So the order to create the deployed scripts should be ..
2nd: package body
But it is created as follows:
1st: view (which becomes INVALID as package body does not exist yet)
3rd: package body.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document