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

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;删掉最后面的‘;’

    评论
    解决 无用
    打赏 举报
查看更多回答(1条)

相关推荐 更多相似问题