Import fails with ORA-39002, ORA-31694, ORA-31644
While running import using an old dump backup impdp was failing with ORA-39002, ORA-31694, ORA-31644 Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options ORA-39002: invalid operation ORA-31694: master table "SYSTEM"."SYS_SQL_FILE_FULL_01" failed to load/unload ORA-31644: unable to position to block number 27248734 in dump file "/d04/bkp/imo_mxdtb_expdp_full_25_05_2021.dmp" The export dump was restore from an archive. After doing a little research we found that the backup dump generated that day was not complete, it has failed due to space constraint on the disk. It was only clear after checking the export log file for that day. Resolution to the problem is only restoring a full intact export backup and continue with the import. Reference : MOS Doc: 1413746.1