Symptoms
Synchronizing an Azure Data Factory - Oracle data source in an Ingest instance takes a very long time, or returns an incomplete or empty list of tables.
Cause
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.
Resolution
Specify an owner who has been granted permissions to the necessary tables. Note that the owner is case sensitive.
