ltl_character_case

The character case used for database object names in Log Transfer Language (LTL) sent to Replication Server.

Default

asis

Values

asis – database object names 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 same character case as they are specified in replication definitions.

lower – database object names are sent in all lowercase, regardless of how they are returned from the primary database, or specified in replication definitions.

upper – database object names in LTL are sent in all uppercase, regardless of how they are returned from the primary database, or are specified in replication definitions.

Comments

  • The ltl_character_case configuration parameter allows you to customize the handling of database object names in LTL to work with replication definitions that specify the object names differently than the way the primary database returns them.

  • If the value of the ltl_character_case parameter is asis, and the value of the use_rssd parameter is true, database object names are sent in the same character case as they are specified in replication definitions.

  • If the value of the ltl_character_case parameter is asis, and the value of the use_rssd parameter is false, database object names are sent in the same character case as they are returned from the primary database.

  • If replication definitions specify database object names in all lowercase, set the value of the ltl_character_case parameter to lower.

  • If replication definitions specify database object names in all uppercase, 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.