RE: join across database link

2001-05-09 Thread Bambi Bellows
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

RE: join across database link

2001-05-09 Thread Tim Sawmiller
This wouldn't be the one and only Bambi Bellows, would it? [EMAIL PROTECTED] 05/09/01 01:42PM 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

join across database link

2001-05-08 Thread blair
A query that has run for a long time has suddenly started hanging. The query joins 3 tables - 2 of them across a link. The query runs on an RDBMS 8.0.5 NT. The tables across the link are on AIX RDBMS 7.3.2.3. All indexes are VALID. When I connect to the NT and run the query by hand it also

Re: join across database link

2001-05-08 Thread Jared Still
Let's do the ez one first. On Tuesday 08 May 2001 11:42, [EMAIL PROTECTED] 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

RE: join across database link

2001-05-08 Thread Kimberly Smith
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, [EMAIL PROTECTED] wrote: When I do a