RE: join across database link

Ooh! Ooh! I did that once! What fun! I had two windows up... both logged in as system. And when I described across the link, it shut down the window I was working in and displayed the error in the other one. And it was reproducible! Ah, the fun stuff Oracle puts in for the adventuresome! Although, nothing really beats Digital and their help on Wombats.

Bambi.
-----Original Message-----
Date: Tue, 08 May 2001 18:20:21 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

> Actually there is a similar bug in 8.1.7. Basically, don't describe
> across db links.
>
> -----Original Message-----
> Sent: Tuesday, May 08, 2001 6:41 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Let's do the ez one first.
>
> On Tuesday 08 May 2001 11:42, blair_at_pjm.com wrote:
> > When I do a describe across the link I get "ORA-12663-Services required by
> > the client not available on the server."
>
> This is a bug, don't worry about it. The only fix is to upgrade your
> database from 7.3 to 8.something. It only affects the 'describe' command.
>
>
> > When I connect to the NT and run the query by hand it also hangs. But I
> > can join the NT table to each of the AIX tables and get instant results -
> I
> > just cannot join all three.
>
> Turn tracing on for the session and check out the trace file. In all
> likelihood the session is not actually hung, just running very slowly.
>
> You can also monitor v$sess_io to see what activity is taking place
> for the session.
>
> Check out the explain plan. Do you have a copy of the explain plan
> from when it worked? Of course you don't, neither does anyone else.
>
> If you did, you could compare them. As it is, take a look at it, as it
> may be rather revealing.
>
> Jared
>
> --
> Please see the official ORACLE-L FAQ: <A HREF="http://www.orafaq.com"
>TARGET="_new"><FONT COLOR="BLUE">http://www.orafaq.com</FONT></A>
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: <A HREF="http://www.orafaq.com"
>TARGET="_new"><FONT COLOR="BLUE">http://www.orafaq.com</FONT></A>
> --
> Author: Kimberly Smith
> INET: kimberly.smith_at_gmd.fujitsu.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 

_______________________________________________
Get your free email from http://www.mail.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bambi Bellows
  INET: ultrageek_at_techie.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).