Re: Quicker process of creating tables over dblinks

From: novice82 <>
Date: Wed, 22 Jul 2009 23:09:27 -0700 (PDT)
Message-ID: <>

Hello Geoff

> IIRC, the optimizer has difficulties calculating potential index usage
> over DBLinks. Assuming that there are indexes on cust_id on both these
> tables, consider creating a view in the source database with the join on
> the tables there, and then select from that view over the DBLink.
> GM

I get an error saying " unable to extend temp segment by 61446 in tablespace.
So working on the source db is not an option. Moreover, I have been instructed not to use that database for any testing purposes. any other ideas ? Received on Thu Jul 23 2009 - 01:09:27 CDT

Original text of this message