Error
ORA-39151: Table "DatabaseName"."TableName" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "DatabaseName"."TableName" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Problem :
1. you might be trying to restore database using IMPDP command and in IMPDP using existing database to restore and used "remap_Table" in your IMPDP command
2. You might try to restore single table using "remap_Table" paramter
Solution:
Use below 3 parameter in your IMPDP command, see below parameter and description
- remap_Table - Specify which table need to map with existing table
- tables - Specify, which particular table need to restore
- table_exists_action - Specify, what should be the action if table already exists, these are of 4 type. {SKIP | APPEND | TRUNCATE | REPLACE}, for more information you can read official website
use below parameter along with the usage, see below:
- remap_Table = OldTableName_InBackup:NewdatabasetableName
- tables = TypeYourTableNameHere
- table_exists_action=Truncate
No comments:
Post a Comment