Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Datapump import of dump file problem

NNeykovMay 3 2017 — edited May 28 2017

Hello everyone,

I have the following problem:

I am trying to execute a full import of a .dmp file on a local server machine through the follwoing Data Pump command:

> impdp dev/***@oracle full=Y dumpfile=FULL_BACKUP_PRODUCTION.DMP logfile=2017_05_03_FULL_IMPORT

The .dmp file is created by Data Pump expdp command (full backup). Afterwards I copied the .dmp file on the local server machine through the Remote Desktop Connection on a remotely mapped local disk drive.

The user with which I am executing the impdp command has privileges for read, write and full_imp_database on the dump file.

The version of the backed up database is the same as the one on which I am trying to import the dump file (Oracle v.12.1.0.1).

Here you can download and see the log file of what is happening after the impdp command execution:

https://uploadfiles.io/bgevw

I am doing this process for the first time and a lot of errors have popped up which I do not know how to fix.

What am I doing wrong ?

I will be grateful if someone could help me as soon as possible.

Regards,

Nikola Neykov

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 25 2017
Added on May 3 2017
33 comments
7,092 views