[Oracle] Data Pump详细使用教程(3)- impdp(二)

2014-11-24 16:16:06 · 作者: · 浏览: 1
正执行导入,而是把导入时所需的DDL SQL写入到SQLFILE里。
TABLE_EXISTS_ACTION=[SKIP | APPEND | TRUNCATE | REPLACE]
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.
APPEND loads rows from the source and leaves existing rows unchanged.
TRUNCATE deletes existing rows and then loads rows from the source.
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.