国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

七、測試網(wǎng)絡(luò)連通否

[oracle@test admin]$ tnsping hsminf

TNSPingUtility for Linux: Version10.2.0.1.0 - Production on 21-MAR-2008 10:59:34

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

/u01/app/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = 10.182.4.65)(PORT = 1521)) (CONNECT_DATA = (SERV

ICE_NAME = infuse01)) (HS = OK))

OK (0 msec)

[oracle@test admin]$ tnsping hsninf

TNSPingUtility for Linux: Version10.2.0.1.0 - Production on 21-MAR-2008 10:59:39

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

/u01/app/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = 10.182.4.65)(PORT = 1521)) (CONNECT_DATA = (SERV

ICE_NAME = infuse02)) (HS = OK))

OK (0 msec)

隨後進(jìn)行lsnrctl restart.

八、在ORACLE中創(chuàng)建DBLink

create public database link test

connect to FKPCB identified by “abc123”

using ‘hsminf’

注意：帳號密碼即為INFORMIX中所開的ODBC帳號,

服務(wù)名稱為tnsnames.ora文件中自行定的services名稱.

測試LINK的可用性:

select * from zx_file@test

九、以上，在linux系統(tǒng)下配置INFORMIX ODBC的驅(qū)動，

通過ORACLE數(shù)據(jù)庫建立相應(yīng)LINK服務(wù)。

為了安全起見，我們可在ORACLE中新開一使用帳號，

立INFORMIX中個別TABLE的VIEW，然後再把這些VIE

賦權(quán)給特定用戶使用.

相關(guān)SQL如下:

createorreplaceviewimg_fileas
select"img01","img02","img03","img04","img05","img06","img07","img08","img09","img10","img11","img12","img13","img14","img15","img16","img17","img18","img19","img20","img21","img22","img23","img24","img25","img26","img27","img28","img30","img31","img32","img33","img34","img35","img36","img37"fromimg_file@test;

grant select on img_file to sfc;

select * from scott.img_file;