Thank you for posting query in Microsoft Q&A Platform.
Kindly try below and see if that helps.
- Check if there are any other processes that are currently accessing the same resource. If so, you may need to wait for them to finish before attempting to access the resource again.
- If there are no other processes accessing the resource, you can try increasing the timeout value for the operation. This can be done by modifying the connection string used to connect to the Oracle database.
- You can also try disabling the NOWAIT option for the operation. This can be done by modifying the query used to load data from the source database.
Hope this helps. Please let me know if any further queries.
Please consider hitting
Accept Answer button. Accepted answers help community as well. Thank you.