ORA-31645 And ORA-31622 Errors Raised During Datapump Import Using ASM Dump File on Non-ASM System

(Doc ID 1133883.1)

Last updated on JUNE 24, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: and later   [Release: 11.2 and later ]
Information in this document applies to any platform.


While using a Datapump dump file copied from an ASM filesystem to import data to a non-ASM system, the following errors may be seen in the Datapump import log:
     ORA-39002: invalid operation
     ORA-31694: master table "SYSTEM"."SYS_IMPORT_FULL_01" failed to load/unload
     ORA-31645: unable to read from dump file "/path/file_name.dmp"
     ORA-31622: premature end of file at block ###

The dump file was copied from the ASM filesystem to the non-ASM filesystem via the
ASMCMD> cp command.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms