Consider the following rules and guidelines when you create an Oracle connection:
•An Oracle table name can have a maximum of 30 characters.
•When you run a task that contains an Oracle database in the Public schema, ensure that the schema does not contain too many objects. If the schema contains too many objects, the task times out. You can remove some objects from the Oracle database or move the objects into another database schema.
•When you run a task for an Oracle database target, ensure that the UTF-8 characters do not exceed the maximum length of the varchar or char fields. Data Integration might truncate UTF-8 characters if they exceed the maximum length of the varchar or char fields.
•If the data that you write from a flat file to Oracle contains Portugese characters, ensure that the code page for the Oracle server is not set to MS Windows Latin 1. Select the code page as ISO 8859-15 Latin 1 when you create an Oracle connection.
•Schema name is case sensitive when the name of the schema contains hyphens.