import a single table from a full export backup and remap it
impdp USERNAME/PASSWORD tables=SCHEMA.TABLE_NAME directory=DPUMP dumpfile=DUMPFILE_%U.dmp
remap_schema=SOURCE:TARGET
REMAP_TABLE=TABLE_NAME:TABLE_NAME_NEW
Optional things above :
- Remove remap if you don't want.
- Add ENCRYPTION_PASSWORD=IF_ANY
No comments :
Post a Comment