Ian, I'd actually recommend a materialized view type solution if it will meet your requirements. (But I recommend rolling your own materialized view rather than using Oracle's syntax).
Locally create an empty table that mirrors the structure of the foreign table you want to join on. Then write a little procedure that will refresh your local table through the dblink. (Be sure to handle exceptions like the dblink being unavailable) Create a job that executes the procedure on a set schedule. It's a little bit more complicated, but a lot more stable. Your local database doesn't have the extreme reliance on the foreign database. In my experience contraints that span multiple schemas/databases lead to alot of problems when one database goes offline or a network hiccup occurs. This way you are dealing with a local copy of the data, which also means it's a heck of alot faster. The only downside is the delay in how often your local data is refreshed. Again, I really don't recommend using Oracle built-in materialized views. You should create the tables manually instead. -Adam On 9/1/05, Ian Skinner <[EMAIL PROTECTED]> wrote: > Deanna, oh I know it can be done, it just takes more lines of code, I think. > I'll see once I stop my lunch time e-mail break and write the code. > > -------------- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > Confidentiality Notice: This message including any > attachments is for the sole use of the intended > recipient(s) and may contain confidential and privileged > information. Any unauthorized review, use, disclosure or > distribution is prohibited. If you are not the > intended recipient, please contact the sender and > delete any copies of this message. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217155 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
