My Oracle Support Banner

LGSBY: 12.2 Tables with Long Identifier> 30 Char Is Showing in DBA_Logstdby_Unsupported (Doc ID 2536695.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 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

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