Oracle Connection Rules and Guidelines
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. Informatica Cloud might truncate UTF-8 characters if they exceed the maximum length of the varchar or char fields.