ORA-39174: Encryption Password Must Be Supplied

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH THAVALI
  • 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