Skip to Main Content

Developer Community

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!

Oracle LogMiner Requirements:The tables or column names selected for mining must not exceed 30 characters.

user-9rr6fSep 26 2023

io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource : Table 'GL_001_XPHARMA_PI_TEXT_TEST_LONG_TABLE' won't be captured by Oracle LogMiner because its name exceeds 30 characters. If the table name exceeds 30 characters, no data will be captured.

The issue isn't with Flink or Debezium, it's the fact that Oracle LogMiner doesn't support such lengthy object names.

Oracle Server 19C Version,So, in response to this issue, I failed to modify the following two system parameters of Oracle without changing the object length,

Alter SYSTEM SET logmnr_ Max_ Column_ Len=50 SCOPE=BOTH;

Alter SYSTEM SET logmnr_ Max_ Name_ Len=50 SCOPE=BOTH;

oracle-alter-sys.jpg

Excuse me, do you not have these two system parameters? If it does not exist, how can I modify the system parameters through Oracle to fix this issue?

Comments
Post Details
Added on Sep 26 2023
0 comments
752 views