Character Case of Database Object Names

Database object names must be delivered to the primary Replication Server in the same format as specified in replication definitions; otherwise, replication fails. For example, if a replication definition specifies a table name in all lowercase, then that table name must appear in all lowercase when it is sent to the primary Replication Server by the Replication Agent.

To control the way Replication Agent treats the character case of database object names sent to the primary Replication Server, set the ltl_character_case configuration parameter to one of these values:

asis – (the default) database object names are passed to Replication Server in the same format as stored in the primary data server.
lower – database object names are passed to Replication Server in all lowercase, regardless of how they are stored in the primary data server.
upper – database object names are passed to Replication Server in all uppercase, regardless of how they are stored in the primary data server.

In the Oracle data server, by default, database object names are stored in all uppercase. However, if you create a case-sensitive name, the case-sensitivity is retained in Oracle.

These examples use the asis option:

create table tabA is stored as TABA
create table Tabb is stored as TABB
create table ‘TaBc’ is stored as TaBc

These examples use the upper option:

create table tabA is rendered in LTL as TABA
create table Tabb is rendered in LTL as TABB
create table ‘TaBc’ is rendered in LTL as TABC