| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: good workaround for a ORA-2016?
Not to mention
select this,that
:)
-----Original Message-----
Sent: Friday, November 09, 2001 8:36 AM
To: Multiple recipients of list ORACLE-L
I like your naming conventions :)
but shouldn't it be
from a_table_in_this_database ?
--- Jeffery Stevenson <jeff_at_mpv.com> 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_at_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_at_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: dcowles_at_i84.net
> >
> >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: ListGuru_at_fatcity.com (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: dcowles_at_i84.net
>
> 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: ListGuru_at_fatcity.com (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: jeff_at_mpv.com
>
> 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: ListGuru_at_fatcity.com (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: Rachel Carmichael INET: wisernet100_at_yahoo.com 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: ListGuru_at_fatcity.com (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: Miller, Jay INET: JayMiller_at_TDWaterhouse.com 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: ListGuru_at_fatcity.com (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).Received on Fri Nov 09 2001 - 13:04:20 CST
 |
 |