Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

GG pump abends with "Source wildcard specification includes a catalog name , but the source table na

3346923Apr 27 2018 — edited May 28 2018

I am trying to configure GG between oracle 12 C (multitenant) and oracle 11g Database (standalone) .

Following is the version of all the components.

SOURCE GG :  OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBO
SOURCE DATABASE : 12c(12.1.0.2.0) (multitenant)

TARGET GG : OGGCORE_11.2.1.0.0OGGBP_PLATFORMS_151212.0607
TARGET DATABASE: 11g(11.2.0.3.0) standalone

and the parameter of the extract and pump are as follows

-----Extract parameter

EXTRACT EPOC
USERIDALIAS schema_alias
TRANLOGOPTIONS BUFSIZE 1000000
TRANLOGOPTIONS _NOREADAHEAD ANY
TRANLOGOPTIONS INTEGRATEDPARAMS (max_sga_size 100)
EXTTRAIL /goldengate/ggadmin/dirdat/EP, FORMAT RELEASE 11.2
TABLE DEVC.SCHEMA.DUMMY_CODE;

-----pump parameter

EXTRACT PPOC
USERIDALIAS schema_alias
RMTHOST 10.24.124.26 MGRPORT 61990, COMPRESS, COMPRESSTHRESHOLD 1000
RMTTRAIL /goldengate/oradata01/ggowner/dirdat/EP, FORMAT RELEASE 11.2
TABLE DEVC.SCHEMA.DUMMY_CODE;

Below log is registerd in the ggserr.log

Trail file /dborafiles/gib/oradata01/ggowner/dirdat/EP format does not support catalog names. The catalog name of the source table DEVC.SCHEMA.DUMMY_CODE specified in TABLE clause 'TABLE DEVC.SCHEMA.DUMMY_CODE' will be removed

Extract has captured all the chnages but when i start the pump it fails with the error
2018-04-27 18:14:49  ERROR   OGG-02649  Oracle GoldenGate Capture for Oracle, ppoc.prm:  Source wildcard specification DEVC.SCHEMA.DUMMY_CODE includes a catalog name, but the source table name

SCHEMA.DUMMY_CODE does not include a catalog name

Apologise if the same has been answered already. Please help my by sharing your comments

This post has been answered by 3346923 on May 17 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 15 2018
Added on Apr 27 2018
8 comments
2,185 views