IMPDP TABLE_EXISTS_ACTION PARAMETER EXPLAINED Data Pump IMPDP TABLE_EXISTS_ACTION = APPEND, REPLACE, [SKIP] and TRUNCATE In conventional import utility (IMP) we have ignore =y option which will ignore the error when the object is already exist with the same name. When it comes to the data pump there is one enhanced option of ignore=y which is called TABLE_EXISTS_ACTION. The values for this parameter give 4 different options to handle the existing table and data. $ impdp help=y TABLE_EXISTS_ACTION Action to take if imported object already exists. Valid keywords are: APPEND , REPLACE , [ SKIP ] and TRUNCATE . SKIP : Default value for this parameter is SKIP. This parameter is exactly same as the IGNORE=Y option in conventional import utility. APPEND : This option appends the data from the data dump. The extra rows in the dump will be appended to the table and the existing dat...
Comments
Post a Comment