数据库链问题

Question

SQL> desc saexpenselog@busdb238sales
Object saexpenselog@busdb238sales does not exist.我通过数据库链想查看一个表的表结构却不能成功,
SQL> crate table saexpenselog select * from saexpenselog@busdb238sales;crate table saexpenselog select * from saexpenselog@busdb238salesORA-00900: invalid SQL statement
这样执行也不能成功,不知道什么原因,
但是select * from saexpenselog@busdb238sales是可以查询出数据的!请高手解决

Answer 1

 crate table saexpenselog 

Answer 2

1 应该是create，而不是crate！2 通过dblink可以查看远程表结构，只是无法对其DDL。
SQL> select db_link from user_db_links;DB_LINK
--------------------------------------------------------------------------------SERVER.REGRESS.RDBMS.DEV.US.ORACLE.COM
ZASIC.REGRESS.RDBMS.DEV.US.ORACLE.COMSQL> desc area@server
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ---------------------------- AREAID                                             NUMBER
 AREACODE                                           VARCHAR2(6)
 AREANAME                                           VARCHAR2(32)
 AREALEVEL                                          CHAR(1)
 PARENTAREAID                                       NUMBER
 STATUS                                             CHAR(1)SQL> desc area@zasic
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ---------------------------- AREAID                                             NUMBER
 AREACODE                                           VARCHAR2(6)
 AREANAME                                           VARCHAR2(32)
 AREALEVEL                                          CHAR(1)
 PARENTAREAID                                       NUMBER
 STATUS                                             CHAR(1)SQL> alter table area@zasic add (goal number);
alter table area@zasic add (goal number)
                 *
第 1 行出现错误:
ORA-02021: 不允许对远程数据库进行 DDL 操作
SQL>

Answer 3

按你说的做了,我这里不行哦
SQL> select db_link from user_db_links;DB_LINK
--------------------------------------------------------------------------------
BUSDB238
BUSDB238SALES
BUSDB595
DBLINK01SQL> desc saexpenselog@busdb238sales;
Object saexpenselog@busdb238sales does not exist.SQL>