Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

351

积分

0

好友

8

主题
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查询吗?
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-25 00:14 , Processed in 0.047249 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569