import into oracle in AIX using telnet

I was tried to import into an oracle 11.2 in AIX using telnet linking into server.


And encountered an error:

$impdp CSMISGRM/CSMISGRM directory=AIXCSMISDBWS dumpfile=CSMIS.DMPDP logfile=impdp.log schemas=CSMISGRM remap_tablespace=CSMISGRM:CSMIS

error message:

With the Partition option

ORA-39002: invalid option

ORA-39070: Unable to open the log file

ORA-39283: invalid file operation

ORA-06512: at “SYS.UTL_FILE”, line 536

ORA-29283: invalid file operation


then i tried using nologfile parameter,

$impdp CSMISGRM/CSMISGRM directory=AIXCSMISDBWS dumpfile=CSMIS.DMPDP nologfile=yes schemas=CSMISGRM remap_tablespace=CSMISGRM:CSMIS

and got:

With the Partition option

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31640: unable to open dump file “/oradata/AIXCSMISDBWS/CSMIS.DMPDP” for read

ORA-31640: unable to obtain file status

IBM AIX RISC System/6000 Error : 2: No such file or directory

Additional information: 3


I had checked the directory, it had been given read and write authority to current user:

$chmod 777 /oradata/AISCSMISDBWS

Then using sqlplus logged into oracle and check the directory. Make sure to include “/” at the beginning (or the end) of the path, such as ‘/oradata/AIXCSMISDBWS/’ when creating the DIRECTORY in the database.

$sqlplus / as sysdba

>create or replace directory AIXCSMISDBWS as ‘/oradata/AIXCSMISDBWS/’;

>grant read,write on directory AIXCSMISDBWS to CSMISGRM;

But there still have the error. I google it and got the answer.

first, check the DATA_PUMP_DIR parameter by using echo command.

$echo “$DATA_PUMP_DIR”

i found the system don’t have this parameter.

then open the profile file of the system, and add this parameter, the value is the directory name:


import again, bingo! success!


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s