LGSBY: 12.2 Tables with Long Identifier> 30 Char Is Showing in DBA_Logstdby_Unsupported
(Doc ID 2536695.1)
Last updated on MAY 07, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
Since Oracle 12.2 table names and column names in Oracle are not limited anymore to 30 char and developers recently have been assigning longer names to some objects they created.
However, in logical standby databases it appears that table_names longer than 30 char or tables that contain a column name longer than 30 char, on the primary database side appear in the view dba_logstdby_unsupported although they do not contain any unsupported datatypes.
The DDL of these tables is replicated in the logical standby but the DML is not.
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