Home » SQL & PL/SQL » SQL & PL/SQL » avoiding cross database links?
avoiding cross database links? [message #214228] Mon, 15 January 2007 08:44 Go to next message
r2d2dev
Messages: 75
Registered: May 2005
Location: bxl
Member
hello,
some time ago i was told to avoid cross-database-links, but i don't know why anymore. now again i'm in the position where making a cross-database-link is the only option left, so i need to be sure about the disadvantages (which i don't remember).
thx.
Re: avoiding cross database links? [message #214231 is a reply to message #214228] Mon, 15 January 2007 08:59 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
If it is the only option left, then, well, it is the only option left!
One thing to keep in mind is that you should avoid 'pulling' large tables over the line when joining.
Re: avoiding cross database links? [message #214235 is a reply to message #214231] Mon, 15 January 2007 09:02 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
By the way, did you mean this thread?
Just checking your posts revealed it, so it wasn't that hard to find.
Re: avoiding cross database links? [message #214239 is a reply to message #214235] Mon, 15 January 2007 09:09 Go to previous message
r2d2dev
Messages: 75
Registered: May 2005
Location: bxl
Member
Frank wrote on Mon, 15 January 2007 14:02
By the way, did you mean this thread?
Just checking your posts revealed it, so it wasn't that hard to find.

Indeed Frank, you're too smart...
but in that thread i find only "cross database links is ugly", "when DBA sees it, he gets a heart attack",... but no real reason why... so that's why i reopened this discussion.

by the way: last year the problem was resolved by a redesign of the database (the missing info of last year is now also in the database, because other applications needed that info too)

[Updated on: Mon, 15 January 2007 09:13]

Report message to a moderator

Previous Topic: Alter teh Indexes
Next Topic: Column justify not working
Goto Forum:
  


Current Time: Sun Dec 04 04:31:28 CST 2016

Total time taken to generate the page: 0.07104 seconds