PROBLEM:
While importing a dump, getting below error:
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORA-39002: invalid operation
ORA-39174: Encryption password must be supplied.
SOLUTION:
The export dump is an encrypted one. I.e while taking export , ENCRYPTION_PASSWORD has been provided.
So for importing also, we need to pass the same password. So get the password and import as below.
dumpfile=emp_enc1.dmp logfile=emp_tab.log directory=VEN tables=dbatest.EMP_TAB ENCRYPTION_PASSWORD=oracle#54322