SYS.DBMS_DATAPUMP' must be declared

impdp DIRECTORY=DIR DUMPFILE=dump_file.DMP LOGFILE=dump_file_log.log PARALLEL=8 EXCLUDE=INDEX remap_schema=Old_User:New_User remap_tablespace=Old_Tablespace:New_Tablespace exclude=statistics 

SYS.DBMS_DATAPUMP' must be declared

When This Error Came:

I tried to restore the Oracle Database and it throws the error. I Used correct credentials to connect oracle database.

My machine has multiple oracle Instances installed.

Both Instances are installed on separate Path.

Solution:

To solve this error i executed below command on CMD window. (make sure you are not entered in SQLPLUS)

SET ORACLE_SID=ORCL

using this command we need to tell the machine, which instance we are plan to use, if you wan to switch your your oracle instance re-run same query after exiting SQLPLUS cmd.