Are you talking about DBLinks ?
Have you checked the Alert log on the local DB and remote DB ? What did you find there ?, Could you post here the messages
Check the user who is used to connect with the DBLink
1 person found this helpful
- Depending on how your clone was created, the clone DB may not have any file in temporary tablespace. Please check first.
- It's not true that when you access via a link, All the operations take place on that database, not on the local one. The optimizer just uses the most efficient way (it thought) to process the query, local or remote.
- If the ORA-01652 occured in remote database, you will most likely receive ORA-02063. Therefore, the error occurred locally.
1.I checked the cloned database, temp files were created. They created ORATMP, and files have been added. I verified their total utilization per datafile is very small (2% at the highest, for 7gb tempfiles)
2.Thanks for that info, That may be why it's saying TEMP, and not ORATMP, which is the temp space on the linked database. It's the insert that causes the error, as I was able to run the sql without the insert from the schema which the user was running from.
Thanks for the help, increasing temp on the local database seemed to do the trick, and the issue has been resolved!