which database shows errors on link connection between two databases

Hello,

I have 2 oracle instances a and b, the instance b makes a joined select on three tables of database a to fetch data.
In some cases the select fails because the temp ist too small. The PL/SQL-script gets the following error:

ERROR at line 1:

ORA-01652: unable to extend temp segment by  256 in tablespace temp
ORA-02063: preceding line from a
ORA-06512: at line 83


But the error ORA-01652 is recorded in the alert-file of database b!


-> ORA-1652: unable to extend temp segment by 256 in tablespace            TEMP

Unfortunately the temp-tablespaces of the two databases have the same name.

So my question is - which temp tablespace is too small? I think the tablespace on database a, but
why is this error (and only this error) recorded in the alert-file of database b?

-- 
__________________________________________________________
News suchen, lesen, schreiben mit http://newsgroups.web.de