-- 创建命名空间
create tablespace YSSUCO datafile 'D:\app\lenovo\oradata\YSSUCO.dbf' size 1 g autoextend on next 64m;
-- 用户设置相应的表空间
create user v45dev identified by V45DEV default tablespace YSSUCO;
-- 给用户授予DBA权限
grant dba to v45dev;
-- 创建数据泵目录(注意路径一定要用反斜杠)
create directory dump_dir AS 'E:\dump_dir';
-- 创建DBLINK
create public database link CONNECT_199 connect to SOFA_DS identified by SOFA_DS using '192.168.103.199/ORCL';
-- 数据泵导出服务器数据
EXPDP test/test network_link=CONNECT_199 directory="dump_dir " dumpfile=SOFA.dmp
-- 数据泵导入本地数据
IMPDP SOFA_DS/SOFA_DS directory="DUMP_TEST " dumpfile=SOFA.dmp
文章标题
最新推荐文章于 2019-04-22 16:39:25 发布