订阅所有JSP/Servlet的日志 订阅 | 这是最新一篇日志 上一篇 | 下一篇日志 下一篇 ]
More

创建DB Link

作者:xiaoliu52013 日期:2007-10-26 09:04:16

字体大小: 小 中 大
创建一个DB Link的语句(这是我在oracle下的语句): 
1
2
3
4
5
6
7
8
9
10
11
create database link linkName
  connect to username identified by password
  using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 116.158.111.25)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBName)
    )
  )'

其中:linkName为你这个db link的名字

username 和password为你login这个数据库account.

116.158.111.25为你选程DB的IP地址

DBName为这个远程DB的名字


创建这个DB Link有什么用呢？
其作用就是访问远程数据库.
当然也存在问题哦,如：
1.能否访问不同的数据库？
2.如果远程数据库出问题了怎么办？
以上问题都是值得考虑的

===============================
thx

平均得分
(0 次评分)





文章来自: 本站原创
标签:
评论: 34 | 查看次数: 2887
  • 共有 34 条评论
  • 1
  • 2
  • 3
    • |
  • >>
    •
kuailele [2010-07-15 14:13:34]
Available in four ‘sinful’ inspired colours each Destiny ghd styler also comes with a matching heat resistant quilted
louis vuitton Geldboersen case and black hard case.ghd has released a limited edition range of hair straighteners in four wickedly inspired colours and matching cases. The Destiny ghd is the must-have style cheap true religionaccessory for the season and now available at Wantthelook.com.
beeflee [2009-10-21 20:02:44]
beeflee [2009-10-21 20:02:30]
游客 [2008-12-04 01:04:09]
游客 [2008-11-22 14:10:04]
游客 [2008-11-20 14:11:01]
游客 [2008-11-15 16:00:33]
游客 [2008-11-14 13:39:54]
游客 [2008-11-12 13:22:22]
游客 [2008-11-07 11:33:12]
游客 [2008-11-07 08:34:16]
游客 [2008-11-04 14:34:40]
游客 [2008-11-04 14:33:45]
游客 [2008-10-30 15:00:49]
buy wow gold Remember the WoW account hacking. buying gold world of warcraft If you're a WoW player. cheap wow gold you couldn't have missed . cheap wow gold any of the articles posting this issue. cheap wow gold Well, as it turns out, an article posted by . cheapest wow gold grimwell says that someone might have found the problem behind all the . eve isk account hacking, stealing and selling even 5 year's worth items. free online games A piece of the BBC news article says:"Analysis [. free online war games mp3 mp3 player ] showed that. mp3 players it lay dormant on a victims . mp4 machine until . online games they ran World of Warcraft (WoW) at which point it captured login data and sent it to. play war games the hacking group. sell wow gold The group's enthusiastic use of the cursor flaw suggests it is trying to . world of warcraft gold do the same again. wow The online fantasy game . wow gold now has more than eight million active players around the world. wow gold Research by security firm Symantec . wow gold suggests that the raw value of a WoW account is now higher. wow gold than a credit card and its associated verification data. wow gold "Normally, as a WoW player, you'd know about the risks involved when creating an online account, yet some were . wow gold lazy enough not to check on their accounts every once in a while, thus resulting in their items . wow gold kaufen and WoW currency being stolen. wow gold kaufen Everyone knows that . stuff like that happen, some. even managed to hack the Superbowl website and use it . to host code for spyware, so monitor the hell out of your computer!In an article I wrote yesterday. about hackers seeing console users as the new target, there is a comment coming from Stefana Muller.
游客 [2008-10-28 16:52:38]
Buy Lotro Gold | Lord Of The Rings Online Gold
Lotro Accounts
| Buy Lotro Accounts
Lord Of The Rings Online Power Leveling | Lord Of The Rings Online PowerLeveling
Lotro Cd Key | Lord Time Card
Lotro Gold | Lotro Gold Instant Delivery
lord of the rings online accounts | lord of the rings online accounts for sale
Lotro Power Leveling | Lotro Powerleveling
Lord Of The Rings Online Cd Key | Lord Of The Rings Online Time Card

Lord of the Rings Online Gold
Buy Lotro Gold
Sell LoTRO Gold
LoTRO CD Key
LoTRO Europe Gold
Cheap LoTRO Accounts
Lord of the Rings Online Power Leveling
Lord of the Rings online CD Key
Cheap Lotro Gold
Air Jordan Shoes
Warhammer Gold
Warhammer Online Gold
Warhammer Accounts
Warhammer Power Leveling
Warhammer Online Key
Warhammer Gold
Warhammer Online Gold
Warhammer Time Card
Warhammer CD Key
WAR gold
warhammer online gold
Buy WAR gold
Buy warhammer gold
Buy warhammer online gold
warhammer gold
WAR Accounts
warhammer Accounts
warhammer online Accounts
Buy WAR Accounts
warhammer Accounts for sale
Warhammer Power Leveling
Warhammer Online Power Leveling
War Power Leveling
Buy Warhammer Power Leveling
Warhammer PowerLeveling
Cheap Warhammer Power Leveling
Cheap Warhammer Online Power Leveling
Buy War Power Leveling
Warhammer EU Power Leveling
Cheap Warhammer Gold
Cheap Warhammer online gold
Buy Cheap Warhammer Gold
Buy WAR Gold
Warhammer EU Gold
Warhammer EU Power Leveling
Warhammer EU CD Key
Warhammer EU Accounts
Warhammer CD Key
Warhammer online CD Key
Warhammer Timecard
Buy Warhammer Time Card
Warhammer 60 days Time Card
Cheap WAR Accounts
Cheap warhammer Accounts
Cheap warhammer online Accounts
Buy Cheap WAR Accounts
buy Warhammer CD Key
buy Warhammer online CD Key
cheap Warhammer CD key
warhammer time card
Warhammer prepaid time card
  • 共有 34 条评论
  • 1
  • 2
  • 3
    • |
  • >>
    •
发表评论
昵　称：  登录
内　容：
选　项:
字数限制 1000 字 | UBB代码 开启 | [img]标签 开启