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.
•Schema name is case sensitive when the name of the schema contains hyphens.