Hi,

I am getting following error while importing data from one schema to another schema.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31650: timeout waiting for master process response.

I ran export first using expdp. I did export from schema1 and took in a dump file schema1.dmp.

Now I am importing the data from schema1 to schema2 using following command:

1) impdp user1/user1@userddb REMAP_SCHEMA=schema1:schema2 table_exists_action=replace directory=DPDATA2 dumpfile=schema1.dmp logfile=schema1.log.

It gave error:

Starting "ONDSCV"."SYS_IMPORT_FULL_01": ondscv/********@qaonddb REMAP_SCHEMA=funcondscvnds
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
ORA-31684: Object type SEQUENCE:"ONDSCV"."MYSEQUENCE" already exists
ORA-31684: Object type SEQUENCE:"ONDSCV"."MYSEQUENCE1" already exists
ORA-31684: Object type SEQUENCE:"ONDSCV"."SEQ_ASSIGNMENT_NO" already exists.

2) Then I ran following:
impdp user1/user1@userddb REMAP_SCHEMA=schema1:schema2 INCLUDE=TABLE directory=DPDATA2 dumpfile=schema1.dmp logfile=schema1.log

It gave error:

onnected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
ith the Partitioning, OLAP, Data Mining and Real Application Testing options
RA-31626: job does not exist
RA-31650: timeout waiting for master process response.

After this error it seems that it gets hanged because I don't see any further message like error or warnings.

Please help what could be the reason and resolution.