ORACLE一个连接 create database link mylink connect to albert identified by Albert4615 using 'lnzd';select * from P_GROUP@mylink; 由于mylink下还有一个数据连接@query,如何通过@mylink查询@query连接下的一个表,假如表名为temp, 查询语句应该如何写?
在lnzd创建视图test_view ,select * from T@query本地执行 select * from test_view@mylink 报错ORA-00600: 内部错误代码, 参数: [kpnxdcbk-2], [], [], [], [], [], [], [], [], [], [], [] 00600. 00000 - "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]" *Cause: This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition. *Action: Report as a bug - the first argument is the internal error number
现在网络权限问题,本地库不能直接访问@query
或者针对这个查询建一个view等等。
00600. 00000 - "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
*Cause: This is the generic internal error number for Oracle program
exceptions. This indicates that a process has encountered an
exceptional condition.
*Action: Report as a bug - the first argument is the internal error number
Oracle 内部错误。 。