My Oracle Support Banner

OCI ADB Serverless: Data Pump Import can't open the dumpfile fails with "ORA-31640: unable to open dump file ... for read" (Doc ID 3000282.1)

Last updated on JANUARY 25, 2024

Applies to:

Autonomous Database Serverless - Version N/A and later
Information in this document applies to any platform.

Symptoms

The Data Pump Import IMPDP can't recognize the dumpfile stored in the Object Storage bucket

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/u03/dbfs/<custom path>/<dumpfile>.dmp" for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
 In Oracle Data Pump, if your source files reside on Oracle Cloud Infrastructure Object Storage you can use Oracle Cloud Infrastructure native URIs or Swift URIs. 
 Import Data Using Oracle Data Pump Version 18.3 or Later
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.