✅Gabarito(Certo)
Caso o inglês não seja o seu forte, assim como no meu caso, poderá fazer uso do tradutor do google...costumo fazer isso! Forma de ir estudando para as questões em inglês que são cobradas.
impdp
Comando utilizado em conjunto com o "expdp" e que faz parte do Data Pump do Oracle, utilizado para migrar um banco de dados de origem local, tablespace, esquema ou tabela para o banco de dados em uma implantação de banco de dados de serviço Database .
Sintaxe - impdp user/pass tables=<table_names> schemas=<schema_name> directory=dumpdir dumpfile=<<schema_name>.dmp logfile=expdp_<schema_name>.log
Fonte:https://oracle-base.com/articles/10g/oracle-data-pump-10g
https://docs.oracle.com/pt-br/iaas/Content/Database/Tasks/mig-data-pump-conventional.htm
table_exists_action
Using a data pump import (impdp), there are four possible actions for table_exists_action:
Sintaxe - TABLE_EXISTS_ACTION = {SKIP | APPEND | TRUNCATE | REPLACE}
As the name implies, table_exists_action is used in impdp when the table already exists in the database where the import is being executed.
table_exists_action=skip: This says to ignore the data in the import file and leave the existing table untouched. This is the default and it is not a valid argument if you set content=data_only.
table_exists_action=append: This says to append the export data onto the existing table, leaving the existing rows and adding the new rows from the dmp file. Of course, the number and types of the data columns must match to use the append option. Just like the append hint, Oracle will not re-user any space on the freelists and the high-water mark for the table will be raised to accommodate the incoming rows.
table_exists_action=truncate: This says to truncate the existing table rows, leaving the table definition and replacing the rows from the expdp dmp file being imported. To use this option you must not have any referential integrity (constraints) on the target table. You use the table_exists_action=truncate when the existing table columns match the import table columns. The truncate option cannot be used over a db link or with a cluster table.
table_exists_action=replace: This says to delete the whole table and replace both the table definition and rows from the import dmp file. To use this option you must not have any referential integrity (constraints) on the target table. You use the table_exists_action=replace when the existing table columns do not match the import table columns.
Fonte: http://www.dba-oracle.com/t_table_exists_action_impdp.htm