Sometimes it happens that we need to import table into an existing table.If we import the table in that schemas it throws error regarding the existence of the particular table.If we have to preserve the old data of table and append the new data,we can use the table_exists_action parameter of data pump.The valid key words are {SKIP | APPEND | TRUNCATE | REPLACE}.
The possible values of the following effects are :
1.) SKIP : leaves the table as is and moves on to the next object. This is not a valid option if the CONTENT parameter is set to DATA_ONLY.By default the value is SKIP .
2.) APPEND loads rows from the source and leaves existing rows unchanged.
3.) TRUNCATE deletes existing rows and then loads rows from the source.
The possible values of the following effects are :
1.) SKIP : leaves the table as is and moves on to the next object. This is not a valid option if the CONTENT parameter is set to DATA_ONLY.By default the value is SKIP .
2.) APPEND loads rows from the source and leaves existing rows unchanged.
3.) TRUNCATE deletes existing rows and then loads rows from the source.
4.) REPLACE drops the existing table and then creates and loads it from the source. This is not a valid option if the CONTENT parameter is set to DATA_ONLY.
No comments:
Post a Comment