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

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

-- 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条回答 默认 最新

  • 六月下起了大雪 2018-10-16 01:40
    已采纳

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

    点赞 打赏 评论
  • 数据甄小白 2018-10-18 02:27

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

    点赞 打赏 评论

相关推荐 更多相似问题