Issues Concerning Table And Column Names Containing Spaces, Hyphen ("-") Or Other Special Characters In ODI
(Doc ID 424100.1)
Last updated on DECEMBER 31, 2019
Oracle Data Integrator - Version 10.1.3.2.0 and later Information in this document applies to any platform.
NOTE: In this article, property values used in examples and commands represent a fictitious sample for clarity and should be replaced by the actual values for use in your environment. Any similarity to actual environments, past or present, or users, living or dead, is purely coincidental and not intended in any manner.
The following issues occur with Oracle Data Integrator (ODI) 10g/11g Integration Interfaces or 12c Mappings:
An Integration Interface / Mapping fails at Insert FK errors step with "invalid character" or "invalid syntax" error messages due to the incorrect name of the primary key column.
The Integration Interface / Mapping fails at Create target table step with " invalid character " message due to the incorrect name specified for the target table.
The Integration Interface / Mapping fails at Load Data step with " invalid character " message due to the incorrect name specified for the table alias.
The 11g mappings / 12c column attributes are not valid: If you click on the target column, the source column is not highlighted, and the SQL code is incorrectly generated for the Integration Interface / Mapping.