I dont get anything after firing DPUMP - IMPDP command

Question

ORACLE_HOME="/oravl01/oracle/11.2.0.4"

impdp /oravl01/oracle/11.2.0.4/bin/impdp AST3APPO/astdb90@CNVABP90 DIRECTORY=DPUMP DUMPFILE=expdp_CUSTOMER_DOX_%u.dmp LOGFILE=CUSTOMER.log JOB_NAME=CUSTOMER_IM TABLE_EXISTS_ACTION=APPEND REMAP_TABLE=CUSTOMER_DOX:CUSTOMER REMAP_SCHEMA=MIGUSER:AST3APPO REMAP_TABLESPACE=migration:migration CONTENT=DATA_ONLY PARALLEL=8

Nothing appears on the screen after that .

Can anyone please help ?

Answer 1

You've figured the initial problem, which was that ORACLE_HOME either wasn't set or wasn't exported in your environment, and your PATH didn't include $ORACLE_HOME/bin. Setting those up in your .profile has fixed that.

You've shown the command you're running as:

impdp /oravl01/oracle/11.2.0.4/bin/impdp AST3APPO/astdb90@CNVABP90 ...

That looks like you've tried a few things before fixing the PATH issue. You've ended up with two references to the binary. The first plain impdp is now being recognised from your PATH, but you also have the full path to the binary as the first argument, and the first argument is interpreted as the username/password. So you need to remove that:

impdp AST3APPO/astdb90@CNVABP90 ...

Or with the full path, which isn't necessary now:

/oravl01/oracle/11.2.0.4/bin/impdp AST3APPO/astdb90@CNVABP90 ...

But not both.