还原到开发机的oracle中
sqlplus / as sysdba
create temporary tablespace xsctemp tempfile '/u01/app/oracle/oradata/consume/xsctemp.dbf' size 1000m autoextend on next 1000m maxsize unlimited extent management local;
create tablespace xsc logging datafile'/u01/app/oracle/oradata/consume/xsc.dbf'size 1000m autoextend on next 1000m maxsize unlimited extent management local autoallocate segment space management auto;
create user xsc identified by xsc default tablespace xsc temporary tablespace xsctemp;
grant connect,resource,dba to xsc;
quit
mkdir /u01/backup/
chown -R oracle.oinstall /u01/backup/
sqlplus / as sysdba
create or replace directory dir as '/u01/backup/';
grant write,read on directory dir to xsc;
quit
cd /u01/backup
rz [xsjl.dmp]
nohup impdp xsc/xsc dumpfile=xsjl.dmp logfile=xsjl.log directory=dir tables=xsjl job_name=xsjl_job &