作了一下测试,没有问题:
SQL> CREATE PUBLIC SYNONYM house
2 FOR [email protected];Synonym created.SQL> select * from house;H H H HSE_NAME H AREA PLACE_NO AREA B
- - - ----------------------------------- - ---- -------- ---- -
1 N 0 House 1 N
2 O 0 Westport House 2 N
3 N 1 Westport - Malaysia Suppliers N
5 N 0 Northport(Distrepark) -External N
6 N 0 Westport (Diperdana) - external N
7 N 0 northport (Tamadam 2) - external N
8 N 0 NORTHPORT (INTEGRATED) - EXTERNAL N7 rows selected.然后用forms4.5中生成一个block指向house这个表,运行能得到结果。你生成的同义词是公共同义词吗?或者是因为访问权限?不过看起来不大像
SQL> CREATE PUBLIC SYNONYM house
2 FOR [email protected];Synonym created.SQL> select * from house;H H H HSE_NAME H AREA PLACE_NO AREA B
- - - ----------------------------------- - ---- -------- ---- -
1 N 0 House 1 N
2 O 0 Westport House 2 N
3 N 1 Westport - Malaysia Suppliers N
5 N 0 Northport(Distrepark) -External N
6 N 0 Westport (Diperdana) - external N
7 N 0 northport (Tamadam 2) - external N
8 N 0 NORTHPORT (INTEGRATED) - EXTERNAL N7 rows selected.然后用forms4.5中生成一个block指向house这个表,运行能得到结果。你生成的同义词是公共同义词吗?或者是因为访问权限?不过看起来不大像
SQL> CONN SBCS/SBCS@V4
已连接。
SQL> create database link CONN_CSSB
2 connect to CSSB identified by CSSB using 'C4';
数据库链接已创建。
SQL> create public synonym syn_user_objects for user_objects@CONN_CSSB;
同义词已创建。
SQL> select * from user_db_links;DB_LINK
--------------------------------------
CONN_CSSB.US.ORACLE.COM SQL> SELECT * FROM DM_MX@CONN_CSSB;DMM DM MC
---------- ---------- --------------
0053 1 是
0053 0 否
0010 01 和平区
0010 03 河北区
0010 04 河东区没什么问题吧?
TO:若水兄,用的就是服务器的TNS.
用的是FORM 6.0
是DBA的权限呀
帮帮忙吧,我实在想不出哪有问题了。
select * from syn_user_objects 呢?
-------------------------------------
DM_DWBGXM
DM_HC
DM_JS
DM_JSQX
DM_KS 可以呀