Skip to main content

Datapump TABLE_EXISTS_ACTION

When datapump import job is started with the option TABLE_EXISTS_ACTION there will be some effects on existing tables.


TABLE_EXISTS_ACTION=SKIP
This is default value and leaves the existing table as it is. (unusable if CONTENT parameter is set to DATA_ONLY)
TABLE_EXISTS_ACTION=APPEND
This appends rows to the table and leaves the existing rows as it is.
TABLE_EXISTS_ACTION=TRUNCATE
This deletes existing rows from the table and inserts rows from the source.
TABLE_EXISTS_ACTION=REPLACE
This drops the existing table, create it again and insert rows from the source. (unusable if CONTENT parameter is set to DATA_ONLY)

Note: it must be considered about the referential contraints on the affected tables when using TRUNCATE and REPLACE options.

Comments

Popular posts from this blog