My Oracle Support Banner

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 to [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 ..
1st: package
2nd: package body
3rd: view

But it is created as follows:
1st: view (which becomes INVALID as package body does not exist yet)
2nd: package
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.