how to import with full database with split export files

user3155148 picture user3155148 · Jan 2, 2014 · Viewed 7.4k times · Source

My client uses the following script to take backup with export datapump:

expdp system/******** logfile=exp_pdco1mob00_full_12232013.txt directory=ABC
 dumpfile=exp_pdco1mob00_full_1_12232013.dmp,exp_pdco1mob00_full_2_12232013.dmp,exp_pdco1mob00_full_3_12232013.dmp,exp_pdco1mob00_full_4_12232013.dmp
full=y exclude=statistics filesize=5g

They give me backup and I have to import full backup on a new machine to debug the error. Can anyone help me how to import full database with impdp?

Thanks in advance

Answer

Husam Mohamed picture Husam Mohamed · Feb 20, 2018

The export was taken using datapump and has been split into 4 files, each file is 5GB or less.


To perform the import on the new machine you will have to do the following:

  • Copy the files to the target machine.
  • Since the export is done using datapump, you will need to create a directory on the database.

Create directory statement, replace PATH with the location of copied files

SQL> Create or Replace Directory ABC as 'PATH';
  • Use the below command to import the full backup/dump. As the dump files are made split, you will have to specify all files under dumpfile parameter

Import command

IMPDP directory=ABC dumpfile=exp_pdco1mob00_full_1_12232013.dmp,
exp_pdco1mob00_full_2_12232013.dmp,
exp_pdco1mob00_full_3_12232013.dmp,
exp_pdco1mob00_full_4_12232013.dmp 
logfile=IMPORT_DUMP full=y