Re: which database shows errors on link connection between two databases

"R. Wiesner" wrote:

> 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

Have your DBA look at freespace in both.

And if there is room on the drives make both temp tablespaces larger. There is little value in having unused hard disk.

Daniel A. Morgan Received on Tue Jun 19 2001 - 17:44:04 CDT