One of the extract group failed with the above error today on 10g database:
Metalink Note: 1558791.1 says that this is db bug and apply a patch 15947884.
The other Note: 1350728.1 (OGG Extract support for Data Type TIMESTAMP WITH TIME ZONE, Oracle to ASCII) says that:
Extract requires the TRANLOGOPTIONS INCLUDEREGIONID or INCLUDEREGIONIDWITHOFFSET to support this data type correctly.
For now, added below to extract parameter and started the extract and it's running fine:
TRANLOGOPTIONS INCLUDEREGIONID
The other option might be considered is by adding below right before userid:
setenv (nls_lang="AMERICAN_AMERICA.US7ASCII")
Formatting error on: table name SCHEMA_NAME.TABLE_NAME,
rowi
d AACjvQAFtAAAFYrAAA, XID 1155.38.90011, position (Seqno 125631, RBA 1673159256). Error converting timestamp with timezone from Oracle to ASCII format for column COLUMN_NAME.
d AACjvQAFtAAAFYrAAA, XID 1155.38.90011, position (Seqno 125631, RBA 1673159256). Error converting timestamp with timezone from Oracle to ASCII format for column COLUMN_NAME.
Metalink Note: 1558791.1 says that this is db bug and apply a patch 15947884.
The other Note: 1350728.1 (OGG Extract support for Data Type TIMESTAMP WITH TIME ZONE, Oracle to ASCII) says that:
Extract requires the TRANLOGOPTIONS INCLUDEREGIONID or INCLUDEREGIONIDWITHOFFSET to support this data type correctly.
For now, added below to extract parameter and started the extract and it's running fine:
TRANLOGOPTIONS INCLUDEREGIONID
The other option might be considered is by adding below right before userid:
setenv (nls_lang="AMERICAN_AMERICA.US7ASCII")
No comments:
Post a Comment