我按照Love_20008的方法试了一下是可以实现的,代码如下: 首先进行适当授权: SQL> connect system/shenrui as sysdba SQL> grant create public database link to kunlun_2008; SQL> grant all on dbms_flashback to kunlun_2008; 建立DB Link: SQL> connect kunlun_2008/kunlun_2008 SQL> create public database link ora10g using 'ora10g '; SQL> select db_link from dba_db_links; SQL> select * from dual@ora10g; 创建表t_22: SQL〉create table t_22 as select * from t1plcbase@ora10g; SQL> select * from t_22;
as
select * from 11
首先进行适当授权:
SQL> connect system/shenrui as sysdba
SQL> grant create public database link to kunlun_2008;
SQL> grant all on dbms_flashback to kunlun_2008;
建立DB Link:
SQL> connect kunlun_2008/kunlun_2008
SQL> create public database link ora10g using 'ora10g ';
SQL> select db_link from dba_db_links;
SQL> select * from dual@ora10g;
创建表t_22:
SQL〉create table t_22 as select * from t1plcbase@ora10g;
SQL> select * from t_22;