TABLE_EXISTS_ACTION option with impdp - Oracle Database Script. TABLE_EXISTS_ACTION OPTION IN IMPDP: TABLE_EXISTS_ACTION Action TO take IF imported OBJECT already exists. VALID keywords ARE: APPEND, REPLACE, [SKIP] AND TRUNCATE. TABLE_EXISTS_ACTION=SKIP: This IS the DEFAULT OPTION WITH impdp. I.e IF the the TABLE EXISTS, it will skip that table. TABLE_EXISTS_ACTION=APPEND: WHILE importing the TABLE, IF the TABLE EXISTS IN the DATABASE, THEN it will append the DATA ON top the EXISTING DATA IN the table. impdp dumpfile=emp_tab.dmp LOGFILE=emp_tab.log directory=VEN table_exists_action=APPEND TABLE_EXISTS_ACTION=TRUNCATE: WHILE importing the TABLE, IF the TABLE EXISTS IN DATABASE, it will TRUNCATE the TABLE AND LOAD the data. impdp dumpfile=emp_tab.dmp LOGFILE=emp_tab.log directory=VEN table_exists_action=TRUNCATE TABLE_EXISTS_ACTION= REPLACE: WHILE importing, IF the TABLE EXISTS IN DATABASE, THEN it will DROP it AND recreate it FROM the DUMP impdp dumpfile=emp_tab.dmp LOGFILE=emp_tab.log directory=VEN table_exists_action= REPLACE
TABLE_EXISTS_ACTION OPTION IN IMPDP: TABLE_EXISTS_ACTION Action TO take IF imported OBJECT already exists. VALID keywords ARE: APPEND, REPLACE, [SKIP] AND TRUNCATE. TABLE_EXISTS_ACTION=SKIP: This IS the DEFAULT OPTION WITH impdp. I.e IF the the TABLE EXISTS, it will skip that table. TABLE_EXISTS_ACTION=APPEND: WHILE importing the TABLE, IF the TABLE EXISTS IN the DATABASE, THEN it will append the DATA ON top the EXISTING DATA IN the table. impdp dumpfile=emp_tab.dmp LOGFILE=emp_tab.log directory=VEN table_exists_action=APPEND TABLE_EXISTS_ACTION=TRUNCATE: WHILE importing the TABLE, IF the TABLE EXISTS IN DATABASE, it will TRUNCATE the TABLE AND LOAD the data. impdp dumpfile=emp_tab.dmp LOGFILE=emp_tab.log directory=VEN table_exists_action=TRUNCATE TABLE_EXISTS_ACTION= REPLACE: WHILE importing, IF the TABLE EXISTS IN DATABASE, THEN it will DROP it AND recreate it FROM the DUMP impdp dumpfile=emp_tab.dmp LOGFILE=emp_tab.log directory=VEN table_exists_action= REPLACE