weixin_41931064
weixin_41931064
采纳率16.7%
2018-10-15 12:03

oracle数据库建立databaselinks连接报错ORA-00900

10
已采纳

-- Drop existing database link
drop public database link A5;
-- Create database link
create public database link A5
connect to CYC_YSL identified by cyc_ysla5;
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.30.111.84)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =doea5dr)
)
)';

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

2条回答

  • qq_40574584 六月下起了大雪 3年前

    ORA-00900是无效的sql,错误在connect to CYC_YSL identified by cyc_ysla5;删掉最后面的‘;’

    点赞 1 评论 复制链接分享
  • weixin_40417658 数据甄小白 3年前

    楼上说的对啊,ORA-00900是无效的sql,sql语句中“;”代表语句结束,执行上面的语句会发现是当成两个语句来执行,所以会报SQL语句无效

    点赞 1 评论 复制链接分享

为你推荐