Weird link problem

AIX 4.3 RDBMS 8.1.6.2 When I select through a database link I have having a strange problem. If I select a field or fields it works. If I select a count it hangs. Any ideas? select count(*) from tab1.table; **hangs** select name, address from tab1.table; **works fine** Help!!! ..tom

Re: Weird link problem

What happens if you do select count(name) from tab1.table? [EMAIL PROTECTED] 04/18/01 09:55AM AIX 4.3 RDBMS 8.1.6.2 When I select through a database link I have having a strange problem. If I select a field or fields it works. If I select a count it hangs. Any ideas? select count(*) from

Re: Weird link problem

You will get the number of non-null values for name. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 10:40 AM What happens if you do select count(name) from tab1.table? [EMAIL PROTECTED] 04/18/01 09:55AM AIX 4.3 RDBMS

RE: Weird link problem

Subject: Re: Weird link problem What happens if you do select count(name) from tab1.table? [EMAIL PROTECTED] 04/18/01 09:55AM AIX 4.3 RDBMS 8.1.6.2 When I select through a database link I have having a strange problem. If I select a field or fields it works. If I select a count