SOLVED

ORA-39174: Encryption Password Must Be Supplied

Asked by OracleDba••13 views•oracle
1
2
3
4
5
ORA-39174: Encryption Password Must Be Supplied

Problem :

While importing a dump file, got this error.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
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
OracleDba•

Post Your Solution