(schema) and use '@aaa' to reference the actual tables/views in the other database. This allows me to indirectly access the secondary db. This allows me to
refer to a db2 database thru Oracle. I hope this helps.
Pat
<cfquery
name='test' datasource='test_db' blockfactor='100' >
select a,b,c,d,e
from [EMAIL PROTECTED]
</cfquery>
-----Original Message-----
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: Friday, August 20, 2004 9:58 AM
To: CF-Talk
Subject: Re: Oracle 8i dblink question
Huh? The second db is slower that this first? Are the boes the same?
Are your indexes the same?
-Adam
----- Original Message -----
From: Whittingham, P <[EMAIL PROTECTED]>
Date: Fri, 20 Aug 2004 08:32:39 -0400
Subject: Oracle 8i dblink question
To: CF-Talk <[EMAIL PROTECTED]>
Hi All,
I am doing a dblink into secondary Oracle 8i database, it seems very
slow in a cfquery (see below). Is there a faster way ??
TIA,
Patrick Whittingham
United Space Alliance
<http://www.houseoffusion.com/banners/view.cfm?bannerid=40> <cfquery
name='test' datasource='test_db' blockfactor='100' >
select a,b,c,d,e
from <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
</cfquery>________________________________
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
