Replicate Abended With OGG-00519 , ORA-00604 PLS-00302: component 'IS_VPD_ENABLED' must be declared
(Doc ID 2747676.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 12.2.0.2.2 and laterInformation in this document applies to any platform.
Symptoms
Replicat abends with below error :
2021-01-28 00:37:42 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [604], ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 3, column 13:
PLS-00302: component 'IS_VPD_ENABLED' must be declared
ORA-06550: line 3, column 5:
PL/SQL: Statement ignored SQL ALTER TABLE "SCHEMA"."TABLENAME" TRUNCATE PARTITION XX DROP STORAGE /* GOLDENGATE_DDL_REPLICATION */], no error handler present.
2021-01-28 00:37:42 ERROR OGG-01668 PROCESS ABENDING.
ORA-06550: line 3, column 13:
PLS-00302: component 'IS_VPD_ENABLED' must be declared
ORA-06550: line 3, column 5:
PL/SQL: Statement ignored SQL ALTER TABLE "SCHEMA"."TABLENAME" TRUNCATE PARTITION XX DROP STORAGE /* GOLDENGATE_DDL_REPLICATION */], no error handler present.
2021-01-28 00:37:42 ERROR OGG-01668 PROCESS ABENDING.
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |