原创：数据泵低到高和高到低版本深入实验.docx

遇到了一个问题，环境描述一下，以便日后能重现环境在研究：环境：刚刚装完12c，然后dbca了一个数据库orcl，建立了一个用户zkm。create directory dir1 as /home/oracle/test;create user zkm identified by zkm account unlock default tablespace users;grant connect,create table to zkm;alter user zkm quota 1m on users;create table zkm.test as select * from scott.emp;其实是想做高低版本的导入导出实验，发现高版本导出的dump文件低版本不可以用，这里是从12c到11g。之前我先做了低到高的实验，就是11g到12c。11g上建立zkm这个用户稍微有些不一样，但是没差，这里也弄出来吧！create user zkm identified by zkm account unlock;grant connect,resource to zkm;create table zkm.test as select * from scott.dept;11g上：expdp zkm/zkm directory=dir1 dumpfile=zkm.dmp logfile=zkm.log12c上：impdp \sys/oracle as sysdba\ directory=dir1 dumpfile=zkm.dmp logfile=zkm.log成功导入。从高到低就不行了，如下：12c上：expdp zkm/zkm directory=dir1 dumpfile=zkm.dmp logfile=zkm.log然后scp过去11g的系统上11g上：[oracle@test test]$ impdp \sys/oracle as sysdba\ directory=dir1 dumpfile=zkm.dmp logfile=zkm.log version=.0ORA-39001: invalid argument valueORA-39000: bad dump file specificationORA-39142: incompatible version number 4.1 in dump file /home/oracle/test/zkm.dmp关于这个version我加了跟没加一样报错。网上有例子是11g到10g加了有用的，也有的说导出的时候加就行了。于是我就想在12c上重新导出一遍，不一样的地方就是加上version=.0（目标版本）。结果出错了。一下环境12c上：[oracle@oracle test]$ expdp zkm/zkm directory=dir1 dumpfile=zkm.dmp logfile=zkm.log version=.0Export: Release .0 - Production on Wed Apr 15 15:25:51 2015Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 12c Enterprise Edition Release .0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsORA-31626: job does not existORA-31633: unable to create master table ZKM.SYS_EXPORT_SCHEMA_06ORA-06512: at SYS.DBMS_SYS_ERROR, line 95ORA-06512: at SYS.KUPV$FT, line 1031ORA-01536: space quota exceeded for tablespace USERS[oracle@oracle test]$ oerr ora 3163331633, 00000, unable to create master table \%s.%s\// *Cause: Job creation failed because a Master Table and its indexes could// not be created, most commonly due to the pre-ex