3,491
社区成员
![](https://csdnimg.cn/release/cmsfe/public/img/topic.427195d5.png)
![](https://csdnimg.cn/release/cmsfe/public/img/me.40a70ab0.png)
![](https://csdnimg.cn/release/cmsfe/public/img/task.87b52881.png)
![](https://csdnimg.cn/release/cmsfe/public/img/share-circle.3e0b7822.png)
copy from bod/bodbod@bod to scott/tiger@snzj insert tab using select * from emp
copy from bod/bodbod@bod to scott/tiger@snzj create tab using select * from emp
导出exp U_NAME/PWD@数据库名 file= d:\data\newsmgnt.dmp tables=(table1)
导入imp U_NAME/PWD@数据库名 file=d:\data\newsmgnt.dmp tables=(table1)
CREATE PUBLIC DATABASE LINK LK
CONNECTION TO USER_NAME IDENTIFIED BY PWD USING '服务名'
CREATE TABLE 表1 AS SELECT * FROM 表2@LK