Home » RDBMS Server » Server Utilities » how to import an encrypted export file
how to import an encrypted export file [message #321175] Mon, 19 May 2008 06:07 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear All,

i got an exp dump file taken with 10g latest expdp with the following command

expdp  system/abcsys schemas=OWNDEV,USRDEV,UPLDDEV ENCRYPTION_PASSWORD=********* directory=EXP_DIR dumpfile=DEV_schema_EXP_lORABITB_May15 logfile=DEV_SCHEMA_EXP_lORABITB_May15log 

now i want to import this file into my local db and my question is will it be successfully imported if i use the following commad

impdp system/orcl123 dumpfile=DATA_PUMP_DIR:DEV_schema_EXP_lORABITB_May15.dmp logfile=DATA_PUMP_DIR:show_orcl1.log schemas=OWNDEV,USRDEV,UPLDDEV ENCRYPTION_PASSWORD=**********

please suggest!
Re: how to import an encrypted export file [message #321448 is a reply to message #321175] Tue, 20 May 2008 05:20 Go to previous message
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Import and see if it successfully done or not.

And ENCRYPTION_PASSWORD is the Password key for accessing encrypted column data. Your heading is confusing to me. With the encryption of export file this parameter has no relation.

It have not to be same as of encrypted column.

[Updated on: Tue, 20 May 2008 05:21]

Report message to a moderator

Previous Topic: Reg IMP-00009: abnormal end of export file
Next Topic: Backup Automation.
Goto Forum:

Current Time: Wed Oct 26 12:23:19 CDT 2016

Total time taken to generate the page: 0.22860 seconds