10 Replies Latest reply: Jan 23, 2014 5:22 PM by petra-K RSS

Table contains one or more variable length columns???

petra-K Expert
Currently Being Moderated

Hi all.

 

GG 11.2.0.1

 

I am replicating 2 mssql table to oracle which are:

ACRBLOCKCARDDETAILS

ACRMASTER

 

One of the pre-reqs is to add trandata:

 

ADD TRANDATA DBO.ACRBLOCKCARDDETAILS

ADD TRANDATA DBO.ACRMASTER

 

The first table has no error, but the 2nd has this error:

==============

2014-01-19 18:57:10  WARNING OGG-01483  The key for table [dtc2.dbo.TRANS_MSTR] contains one or more variable length columns. 

These columns may not have their pre-images written to the transaction log during updates.  Please use KEYCOLS to specify a key for Oracle GoldenGate to use on this table.

 

When I describe structure of the two tables, they are  similar. What makes GG flag the 2nd table as having variable length columns? Thanks a lot.

 

=============

 

CREATE TABLE [dbo].[ACRBlockCardDetails](

    [TransId] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,

    [ApplicationId] [varchar](15) NULL,

    [ACRNumber] [varchar](15) NOT NULL,

    [CardSerialNumber] [varchar](50) NOT NULL,

    [CardIssuerNumber] [int] NULL,

    [CardStatus] [varchar](5) NULL,

    [BlockDate] [datetime] NOT NULL,

    [Remarks] [varchar](50) NULL,

    [Username] [varchar](30) NULL,

    [BlockReason] [smallint] NULL,

    [AmendmentId] [bigint] NULL,

CONSTRAINT [PK_ACRBlockCardDetails] PRIMARY KEY CLUSTERED

(

    [TransId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

 

==============

 

CREATE TABLE [dbo].[ACRMSTR](

    [SSRNID] [varchar](20) NOT NULL,

    [LASTNAME] [varchar](100) NULL,

    [FIRSTNAME] [varchar](100) NULL,

    [MIDDLENAME] [varchar](100) NULL,

    [ALIASNAME] [varchar](100) NULL,

    [FULLNAME] [varchar](500) NULL,

    [BDATE] [varchar](10) NULL,

    [GENDER] [varchar](1) NULL,

    [CITIZENOF] [int] NULL,

    [STATUS] [smallint] NULL,

    [REG_DATE] [datetime] NULL,

    [LOC_ID] [smallint] NULL,

CONSTRAINT [PK_REG_MSTR] PRIMARY KEY CLUSTERED

(

    [SSRNID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

 

GO

 

==============

 

 

 

I

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points