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
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:
Create directory statement, replace PATH with the location of copied files
SQL> Create or Replace Directory ABC as 'PATH';
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