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 MAY 07, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Goal

 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.

Solution

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
Goal
Solution
References


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