ORA-01747 - Asynchronous Change Data Capture (CDC) (Doc ID 1270375.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Symptoms

Using Oracle Asynchronous CDC and DBMS_CDC_PUBLISH  package.

Tables and columns starting with a '/' causes the apply proces to abort with error: ORA-01747: invalid user.table.column, table.column, or column specification.

In addition to the above error, a coredump maybe dumped as follows when attempting to print details of the transaction:
ORA-07445: exception encountered: core dump [lxsRepStr()+340] [SIGSEGV]
[ADDR:0xDA] [PC:0x1E2C2C0] [Address not mapped to object] []

----- Current SQL Statement for this session (sql_id=2h65gr3yf7dmq) -----
BEGIN print_transaction('16.17.182'); END;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x83e9a8ab0 571 SYS.LCR$_ROW_RECORD
0x83f54a820 50 procedure CDCADMIN.PRINT_LCR
0x83f7e0928 28 procedure CDCADMIN.PRINT_TRANSACTION
0x84df34790 1 anonymous block


Functions in the stack include:
lxsRepStr
knclgVal2Str
knclgLcrGetRowStmt
knllgrt

Changes

Attempting to use Asynchronous CDC with tables that have characters such as '/' in the table or column names.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.