The character case used for database object names in LTL.
asis
asis – Database object names in LTL are sent in the same character case as they are returned from the primary database, or (if the value of the use_rssd parameter is true) in the character case they are specified in replication definitions.
lower – Database object names in LTL are sent in all lowercase, regardless of how they are returned from the primary database or specified in replication definitions.
upper – Databse object names in LTL are sent in all uppercase, regardless of how they are returned from the primary database or specified in replication definitions.
The ltl_character_case configuration parameter allows you to customize the handling of database object names in LTL to work with existing replication definitions that specify the object names differently than the way the primary database returns them.
Mirror Replication Agent does not support replicating
multiple tables (or multiple columns in a table) with names that
differ only in character case (for example, mytable and MyTable,
or mycol and MYCOL).
If the value of the use_rssd parameter is false and the value of the ltl_character_case parameter is asis, database object names in LTL are sent in the character case returned from the primary database.
If the value of the use_rssd parameter is true and the value of the ltl_character_case parameter is asis, database object names in LTL are sent in the character case specified in the replication definitions (stored in the RSSD).
If database object names are specified in all lowercase in replication definitions, set the value of the ltl_character_case parameter to lower.
If database object names are specified in all uppercase in replication definitions, set the value of the ltl_character_case parameter to upper.
If you want to send database object names with mixed character case (for example, MyTable), set the value of the ltl_character_case parameter to asis.
