- 20 Dec, 2023
- 0 Comments
- 1 Min Read
ORA-39174: Encryption Password Must Be Supplied
Problem :
While importing a dump file, got this error.
Solution :
If exported dump file is an encrypted one. then we need to pass the same password while importig the dump file.Â
so get the password & import as below :
dumpfile=emp_sal.dmp logfile=emp_tab.log directory=VEN tables=test.EMP_TAB ENCRYPTION_PASSWORD=Oracle#1234