文章标题

-- 创建命名空间
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