- 最后登录
- 2016-6-27
- 在线时间
- 134 小时
- 威望
- 351
- 金钱
- 2586
- 注册时间
- 2012-3-16
- 阅读权限
- 60
- 帖子
- 188
- 精华
- 6
- 积分
- 351
- UID
- 309
|
1#
发表于 2012-4-19 09:41:54
|
查看: 3210 |
回复: 0
在透明网关的配置中有这么一步“Create SQL Server Views for Data Dictionary Support”
To enable Oracle data dictionary translation support use the dg4msql_cvw.sql script, located in the directory ORACLE_HOME\dg4msql\admin where ORACLE_HOME is the directory under which the gateway is installed. You must run this script on each SQL Server database that you want to access through the gateway. Use isql to execute the script, as follows:
> isql -Usa_user -Psa_pwd [-Sserver] [-ddatabase] -e -i dg4msql_cvw.sqlwhere sa_user and sa_pwd are the SQL Server system administrator user ID and password respectively.
我知道这一步应该是在sql server中建立相关的数据字典,不过具体有什么用呢?就是方便dba查询吗? |
|