3,494
社区成员




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