ORA-01747 - Asynchronous Change Data Capture (CDC)
(Doc ID 1270375.1)
Last updated on FEBRUARY 06, 2017
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |
| This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. |