Unfortunately, I don't think I can do that.. they query itself has a limiting factor in the start with clause.. i.e. start with key = (select something from table_over_here,table_over_here2,table_over_here3,table_over_here4 where a bunch_of_stuff and x=:avaluethatchanges)
I can't make a view like that.. On Thu, 08 Nov 2001 23:15:17 -0800, you wrote: >...and you created the view on the "other" side of the database link where >none of the tables are remote tables? Basically, on the remote system you >would create a view like this: > >create view call_this_from_somewhere_else as >select this and that >from a table in this database >start with primary key in (select same datatype from another table > b,c,d(several other tables) >connect by >prior etc., hierarchy > >...and then from the other system you'd call: > >select * from call_this_from_somewhere_else@remote_db; > > >Jeffery Stevenson >Databeast Slayer >Medical Present Value, Inc. >Austin, TX > > >-----Original Message----- >Sent: Thursday, November 08, 2001 9:50 PM >To: Multiple recipients of list ORACLE-L > > >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). >-- >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).