That doesn't work.. same error. It doesn't like remote tables in the start with clause whether it's a view or not.
On Thu, 08 Nov 2001 07:50:29 -0800, you wrote: >If all the remote tables are on the same database and you have privileges to >create a view on that remote database, then create a view at that end and >then just select * from view@remotedb; and be done with it. This is also a >good trick to remember for some of the slower running remote queries out >there. Anyways, just and idea... > >Jeffery Stevenson >Databeast Slayer >Medical Present Value, Inc. >Austin, TX > > >-----Original Message----- >Sent: Thursday, November 08, 2001 9:05 AM >To: Multiple recipients of list ORACLE-L > > >Does anyone know a good workaround for an ORA-2016? :cannot use a subquery >in a >start with on a remote database? > >Query is essentially something like: > >select this and that >from a remote table over a database link >start with primary key in (select same datatype from another remote table > b,c,d(several other remote tables) >connect by >prior etc., hierarchy > >Anyway.. the way they've worked around it is to run the subquery by itself >and >then pump the values 1000 at a time into an IN clause. This is horrible for >parsing. There must be a better way. I was thinking there may be away to >pump the values into a array of number or something. Or, possibly someone >else >has a better idea.. > >Thanks, >Doug >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Doug C > INET: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).