Oracle 11G 数据导入

创建用户 create user ckhx(用户) identified by 1(密码);

权限 grant connect,resource,dba to ckhx;

grant unlimited tablespace to ckhx;

create directory dpdata1(路径变量名) as 'd:\bak';--建个目录

//select * from dba_directories; --查询目录是否建立成功

grant read,write on directory dpdata1(路径变量名) to ckhx(用户) ;--给用户赋予文件的读写权限

grant all on directory dpdata1 to public;

impdp ckhx/1(用户名和密码) directory=dpdata1(路径变量名) dumpfile=NCCLMWL.DMP(数据) job_name=cases_import