Does HVR Replicate Case-Sensitive Table or Column Names?

Question

Can HVR replicate case-sensitive table or column names?

Environment

HVR

Answer

Yes, you can use the LocationProperties /CaseSensitiveNames action if any of the tables or columns in the replication setup (channel) have case-sensitive names. This action is particularly important against Oracle databases as they assume table and column names to be case-insensitive, unless specified otherwise.

The action LocationProperties /CaseSensitiveNames ensures that the table and column names are treated as case-sensitive. This action always applies to all tables in a channel and is required before the tables are added to the channel. If any existing table or column names are case-sensitive, you need to remove and add them again.

You may see the following error if a table or column name is case-sensitive and the above action is not defined for it:

• F_JD0006: A table named [.] does not appear in the DBMS catalogs during Table Explore/Table Select.

• ORA-00942: table or view does not exist during a Refresh.

• ORA-00904 "": invalid identifier, e.g. during a Refresh. This may be an indication that the column reported in uppercase may in fact be in mixed case in the database.