导入数据报错：ORA-39083、ORA-02195
create directory yderpdata_dir as 'D\EASBAK';select * from dba_directorieschown -R oracle.oinstall /orclbakchmod -R 775 /orclbak注意创建表空间以及授权时 建议账号sys/admin以sysdba身份进行创建以及授权 否则无法导入，因为在导入时会找不到对应的用户以及视图//设置自动增长 create tablespace EAS_D_YDJT_STANDARD datafile 'D:\app\Administrator\oradata\EAS_D_YDJT_STANDARD.dbf' size 20000M AUTOEXTEND on; 导入过程： create temporary tablespace EAS_D_YDJT_TEMP2 tempfile 'D:\app\Administrator\oradata\EAS_D_YDJT_TEMP2 .dbf' size 5000M AUTOEXTEND on;create temporary tablespace EAS_D_YDERP0723_TEMP2 tempfile 'D:\app\Administrator\oradata\EAS_D_YDERP0723__TEMP2 .dbf' size 5000M AUTOEXTEND on; //创建用户并给他默认的表空间 create user ydeas identified by ydeas account unlock default tablespace EAS_D_YDJT_STANDARD temporary tablespace EAS_D_YDJT_TEMP2;//授权grant dba to ydeas;impdp system/Admin123 remap_schema=YDERP0723:ydeas remap_tablespace=EAS_D_YDERP0723_STANDARD:EAS_D_YDJT_STANDARD directory=yderpdata_dir parallel=2 dumpfile=20171025.dmp logfile=20171025.log报错信息：ORA-02195: 尝试创建的 PERMANENT 对象在 TEMPORARY 表空间中失败的 sql 为:CREATE TABLE "YDEAS"."VT15968IDO5P4KBNM67LY19NW8" ("KSQL_SEQ" NUMBER(*,0), "SQL_BATCH" NUMBER(10,0), "FACCOUNTID" VARCHAR2(44 BYTE), "FBOOKEDDATE" TIMESTAMP (6), "FBIZDATE" TIMESTAMP (6), "FPERIOD" NUMBER(10,0), "VOUCHERTYPEID" VARCHAR2(44BYTE), "VOUCHERID" VARCHAR2(44 BYTE), "VOUCHERNUMBER" NVARCHAR2(500), "FCREATETIME" TIMEORA-39083: 对象类型 TABLE:"YDEAS"."VT15968IDZ2FWXT9U9KVC56SVQG" 创建失败, 出现错误:ORA-02195: 尝试创建的 PERMANENT 对象在 TEMPORARY 表空间中失败的 sql 为:CREATE TABLE "YDEAS"."VT15968IDZ2FWXT9U9KVC56SVQG" ("KSQL_SEQ" NUMBER(*,0), "SQL_SEQ" NUMBER(10,0), "SQL_BATCH" NUMBER(10,0)) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GR
是的 知道怎样处理吗？我是一个新手 弄了3天了 这个问题还是处理不了 望求各位大神帮助