前置信息
还原文件中
表空间名称: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;