Hi ,
I am doing import of table using parfile with query option. My import is running is running from 4 hours where as export get completed with in half hours???
Kindly suggest...
query_imp.par
--------------------------------------
tables=ABC
query=ABC:"WHERE TIMESTAMP BETWEEN '09/20/2013 00:00:00' AND '10/09/2013' "
logfile=import_ABC.log
parallel= 3
DIRECTORY=export_ABC
DUMPFILE=export_ABC_%U.dmp
table_exists_action=APPEND
CONTENT=ALL
JOB_NAME=import_ABC
while executing the command:
impdp SYSTEM/*****@orcl parfile=/***/***/query_imp.par
O/P:
----------------
Starting "SYSTEM"."IMPORT_ABC": SYSTEM/********@ORCL tables=ABC parfile=/***/***/query_imp.par
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39152: Table "XYZ"."ABC" exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Why status is 100% completed where job is running ????
and STATUS is:
--------------------
Import> STATUS
Job: IMPORT_ABC
Operation: IMPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 5
Job Error Count: 0
Dump File: /**/**/export_ABC_%u.dmp
Dump File: /**/**/export_ABC_01.dmp
Dump File: /**/**/export_ABC_02.dmp
Worker 1 Status:
State: WORK WAITING
Worker 2 Status:
State: EXECUTING
Object Schema:XYZ
Object Name: ABC
Object Type: TABLE_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Completed Bytes: 55,512,836,576
Percent Done: 100
Worker Parallelism: 1