1.in init.ora file set glbal_name=false,create a dblink to link two db, 2.then you use statement like this: insert into text (select * from dbLinkName@text);
1.in init.ora file set global_name=false,create a dblink to link two db, 2.then you use statement like this: insert into text (select * from dbLinkName@text);or use exp/imp
或者用pb的数据通道 很容易的简单来说还是exp/imp
或者用SQL Server带的DTS也不错的
建个DB_LINK,比如建个DB LINK名字为PASUNCC(建DB LINK的时候需要提供用户名和密码,另外,需先修改本机的tnsnames.ora文件,增加另外一个数据库的配置) 就可以这样写了:INSERT INTO TEXT SELECT * FROM PASUNCC.TEXT
2.insert into ...
imp .....
2.then you use statement like this:
insert into text (select * from dbLinkName@text);
2.then you use statement like this:
insert into text (select * from dbLinkName@text);or use exp/imp
很容易的简单来说还是exp/imp
就可以这样写了:INSERT INTO TEXT SELECT * FROM PASUNCC.TEXT