Scenario is you have database/User already exists and received a new Database Backup and you want to restore only 1 table instead of full database restore. And you want to restore table in existing database/User. So you need to use 3 new parameters in your existing restore IMPDP command. These are as below:
- remap_Table
- tables
- table_exists_action
Full IMPDP command
DIRECTORY=DirectoryName
DUMPFILE=Backupname.DMP
LOGFILE=AnyFileName.log
PARALLEL=8
EXCLUDE=INDEX
remap_schema=OldUser_Inbackup:NewUser
remap_tablespace=OldTablespace_Inbackup:NewTablespace
exclude=statistics
--New Paramaters
remap_Table = OldTableName_InBackup:NewdatabasetableName
tables = TypeYourTableNameHere
table_exists_action=Truncate
No comments:
Post a Comment