Boa noite Portilho,
Estou montando um laboratório de migração do Oracle com o Golden Gate e me deparei com o erro abaixo.
Pesquisei no Google e não encontrei a solução.
Não é possível utilizar o GoldenGate em um pdb?
*** Trigger based DDL Replication is not supported on a Multitenant database.
[oracle@target goldengate]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Jan 7 19:50:54 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
SQL> alter session set container=orclpdb;
Session altered.
SQL> @marker_setup.sql
Marker setup script
You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter Oracle GoldenGate schema name:ggadmin
Marker setup table script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to GGADMIN
MARKER TABLE
-------------------------------
OK
MARKER SEQUENCE
-------------------------------
OK
Script complete.
SQL>
SQL>
SQL> @ddl_setup.sql
Oracle GoldenGate DDL Replication setup script
Verifying that current user has privileges to install DDL Replication...
BEGIN
*
ERROR at line 1:
ORA-20783:
Oracle GoldenGate DDL Replication setup:
*** Trigger based DDL Replication is not supported on a Multitenant database.
ORA-06512: at line 14
Disconnected from Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production