Re: Quicker process of creating tables over dblinks
From: novice82 <novice82_at_gmail.com>
Date: Wed, 22 Jul 2009 23:09:27 -0700 (PDT)
Message-ID: <efbc7001-9985-454a-a32b-198ad70e67b0_at_2g2000prl.googlegroups.com>
Hello Geoff
Date: Wed, 22 Jul 2009 23:09:27 -0700 (PDT)
Message-ID: <efbc7001-9985-454a-a32b-198ad70e67b0_at_2g2000prl.googlegroups.com>
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