Follow

Reading objects from an Oracle data source produces unexpected results

Symptoms:

Reading objects from an Oracle data source takes a very long time, or returns an incomplete or empty list of tables.

 

Error Message:

None

 

Underlying Problem:

Which tables appear when reading fields from an Oracle data source depend on the permissions assigned to the owner designated in the connection.  If the owner has insufficient permissions, some or all of the necessary tables may not appear.  If you do not specify an owner, and have blanket permission to view all of the tables in your database, reading fields may take longer than necessary to complete. 

This is because Oracle databases tend to be very highly normalized, and may contain tens of thousands of tables.  Restricting the synchronization to only the necessary tables using owner permissions may speed up this process.

 

Solution:

Specify an owner who has been granted permissions to the necessary tables.  Note that capitalization can affect owner permissions checks; see this article.

 

Return to Oracle Troubleshooting Hub

Author: Doug Wynkoop

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.