This topic describes how to migrate or synchronize a database object whose name exceeds 30 bytes in length from Oracle Database of version 12c or later.
Procedure
Execute the following statement as the SYS user to modify parameters of Oracle Database:
ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION=true SCOPE=BOTH;
Notice
To modify the
ENABLE_GOLDENGATE_REPLICATIONparameter, you must ensure that Oracle Database has an Oracle GoldenGate (OGG) license. However, you do not need to install OGG.For Oracle Real Application Clusters (RAC), you need to modify the parameters for all Oracle instances. You do not need to restart Oracle Database.
If Oracle Database is deployed in Active Data Guard (ADG) mode, to pull data from a standby database, set these parameters in the ADG source database.
Alternately execute the following statement on each Oracle instance for three times.
ALTER SYSTEM SWITCH LOGFILE;After 10 minutes, re-create a data migration project.
Set the
deliver2store.logminer.need_check_object_lengthparameter of the Store component tofalse.Execute the following statement to query the
ENABLE_GOLDENGATE_REPLICATIONparameter.SELECT K.KSPPINM,V.KSPPSTVL FROM SYS.X$KSPPI K,SYS.X$KSPPSV V WHERE K.INDX=V.INDX AND UPPER(K.KSPPINM) = 'ENABLE_GOLDENGATE_REPLICATION';