导入oracle备份dp文件

1、创建表空间

create tablespace TBS_USER
logging  
datafile 'E:\app\Administrator\admin\orcl\dpdump\user_data.dbf'
size 1024m  
autoextend on  
next 100m maxsize UNLIMITED  
extent management local;

2、创建用户
create user cf_test identified by cf_test
default tablespace tbs_user ;

3、授权
grant connect,resource,dba to cf_test;

4、创建授权目录，将dp文件放到目录下
create directory DPDATA2 as 'd:\test\dump';

//查询是否创建成功
select * from dba_directories;

5、打开cmd命令行执行
impdp cf_test/cf_test directory= DPDATA2 dumpfile= CF_LABEL2020Dec02.dp