table_exists_action=truncate takes more time
My customer is on 10.2.0.4 ( in SR 7282685.992 )
[smlora:jeetest1n]/data/t0430/oradata/POC0GIP>cat impdp.par
DIRECTORY=gip_dump1
dumpfile=TGIPR_LURNFACTOR_MOTOR_TEMP01.dmp
logfile=TGIPR_LURNFACTOR_MOTOR_TEMP01.dmp.log
tables=TGIPR_LURNFACTOR_MOTOR_TEMP
table_exists_action=truncate
[smlora:jeetest1n]/data/t0430/oradata/POC0GIP>impdp parfile=impdp.par
Import: Release 10.2.0.4.0 - 64bit Production on Tuesday, 18 November, 2008 11:00:19
when he specified table_exists_action=truncate , it takes 25 minutes to do the Datapump Import.
I suggested to drop the table and do the datapump import which took just 5 minutes.
Any idea on this ?
See his update
SQL> drop table TGIPR_LURNFACTOR_MOTOR_TEMP;
Table dropped.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
[smlora:jeetest1n]/data/t0430/oradata/POC0GIP>impdp parfile=impdp.par
Import: Release 10.2.0.4.0 - 64bit Production on Tuesday, 25 November, 2008 16:36:12
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Username: calcengine_own_gip
Password:
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
Master table "CALCENGINE_OWN_GIP"."SYS_IMPORT_TABLE_02" successfully loaded/unloaded
Starting "CALCENGINE_OWN_GIP"."SYS_IMPORT_TABLE_02": calcengine_own_gip/******** parfile=impdp.par
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "CALCENGINE_OWN_GIP"."TGIPR_LURNFACTOR_MOTOR_TEMP" 4.076 GB 30091922 rows
Job "CALCENGINE_OWN_GIP"."SYS_IMPORT_TABLE_02" successfully completed at 16:40:57
4 1/2 minutes compared to around 25 minutes for the previous test.