This content has been marked as final. Show 5 replies
Can you post the output of
select object_name, object_type from user_objects where object_name = 'TEMP_TBL'
I suppose it is a synonym pointing to remote table.
KaiS wrote:Even if you remove the hint as suggested ?
b) checked notes [ID 49056.1] and [ID 292442.1].
helpless.. any idea ?
Tried removing the hints also..doesn't work.
There is only one object in the db with that name and it is a db ..
Please, remove all the hint and retry. Paste the result here.
And/or start a new transaction and retry. Paste the result here.
And give us your local Oracle db version, your remote Oracle db version, as well as OS (local/remote).