oracle视图取一行,我从远端oracle视图中获取数据的过程

还原到开发机的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 &