Depending on what the original name of the schema was in the source instance, you might want to try running the following statement:
impdp system/******** schemas=Population directory=test_dir dumpfile=expdp.DMP
- Ensure the name of the schema you are importing with the
schemas parameter is indeed
Population. If not insert the correct schema name.
- Please verify that the name used for the
dumpfile parameter is
expdp.DMP and not for example
expdp.dmp (Relevant if you are on a Linux OS)
Quotes are not usually required when adding parameters. In some cases you might have to escape the quotes as pointed out by other answers. Oracle recommends:
Some operating systems treat quotation marks as special characters and will therefore not pass them to an application unless they are preceded by an escape character, such as the backslash (). This is true both on the command line and within parameter files. Some operating systems may require an additional set of single or double quotation marks on the command line around the entire parameter value containing the special characters.
To avoid having to supply additional quotation marks on the command line, Oracle recommends the use of parameter files.
Reference: Use of Quotation Marks On the Data Pump Command Line (Oracle Docs 11.2)
You could put all your parameters in a
impdp_mydump.par file like this:
and then run the import like this:
impdp system/******** parfile=impdp_mydump.par
Permissions / Privileges
In some cases if the user
system doesn't have access to the
directory you might have either grant access to the export directory via:
GRANT READ,WRITE ON DIRECTORY test_dir TO system;
Reference: Oracle Data Pump Quick Start (Oracle.com / PDF)
...or run the
impdp command with the
In some rare cases where either
system have to many roles assigned to their accounts, you might have to run the
impdp command with a dedicated
import account that you would have to create from scratch.