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:

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:
These examples use the upper option: