oracle 导出导入dmp文件

--创建表空间
CREATE tablespace CDZ_DATA datafile 'E:\oracledate\CDZ_DATA.DBF' size 1024m autoextend on next 50m;


--创建用户  CDZGL 
drop user CDZGL cascade;

create user CDZGL identified by CDZGL default tablespace CDZ_DATA;
-----给 用户授权
grant create session to CDZGL; 
grant unlimited tablespace to CDZGL;
grant create table to CDZGL;
grant dba,connect,resource,select any dictionary,create any view,create materialized view to CDZGL;

--创建directory并授权目录 
select * from all_directories;
grant read,write on directory DUMP to CDZGL;
 
--数据导入  运行 —> cmd，导入dmp文件：

impdp CDZGL/[email protected] directory=DUMP dumpfile=ZHISTORYLOAD.dmp logfile=ZHISTORYLOAD.log full=y;


---数据导出

exp 用户名/用户密码@数据库实例 file=导出dmp 文件路劲 log=日志路径.log /tales=用户下的表 full=y