Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Queries across databases
HansF wrote:
> On Mon, 07 Nov 2005 09:24:26 -0800, Andy Kent wrote:
>
>>Is it possible a query a database other than the one to which one is >>currently connected? Specifically, is it possible to do an INSERT INTO >>... SELECT across databases?
Also keep in mind that it'll be dog slow if you're trying to join large tables across the dblink. For instance you want to avoid this kind of query if m and y are of reasonable size:
select * from mytable m, yourtable_at_db_link.world y where m.pk=y.pk
//Walt Received on Mon Nov 07 2005 - 13:04:56 CST