I like your naming conventions :) but shouldn't it be
from a_table_in_this_database ? --- Jeffery Stevenson <[EMAIL PROTECTED]> 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 > -- > Author: Jeffery Stevenson > 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). __________________________________________________ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).