Windows还原Oracle数据库

前置信息

还原文件中
表空间名称：NNC_DATA01
用户名称：NCC10

CREATE TABLESPACE NNC_DATA01 LOGGING DATAFILE 'C:\app\Luo_d\oradata\orcl\NNC_DATA01.dbf'  SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 500M EXTENT MANAGEMENT LOCAL; 
 
create temporary tablespace NNC_DATA01_TEMP tempfile 'C:\app\Luo_d\oradata\orcl\NNC_DATA01TEMP.dbf' size 100m autoextend on next 32m maxsize 500m extent management local; 

create user NCC10 identified by NCC10 default tablespace NNC_DATA01 temporary tablespace ncc_bochk_tim_temp; 
 
grant CONNECT,RESOURCE,DBA,EXP_FULL_DATABASE,IMP_FULL_DATABASE to NCC10; 
 
alter user NCC10 account unlock; 

impdp NCC10/NCC10@orcl dumpfile=0510.dmp logfile=0510.log;