Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

impdp using parfile...

974882Oct 9 2013 — edited Oct 11 2013

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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 8 2013
Added on Oct 9 2013
7 comments
2,347 views