Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import one table from backup

Johnny BMar 29 2022 — edited Mar 29 2022

Hi all,
I did a full backup from my db using expdp.
How can I restore one table from the backup with different table name?
I did the next command:
impdp myDB ******** VERSION=12.2 DIRECTORY=IMP_DIR DUMPFILE=STABLES.dmp CONTENT=DATA_ONLY EXCLUDE=STATISTICS LOGFILE=STABLES.log TABLES=myDB.ORG_DATA remap_table=ORG_DATA:ORG_DATA_COPY;
Getting error:
ORA-39002: invalid operation
ORA-39166: Object REMAP_TABLE.ORG_DATA_COPY; was not found or could not be e
xported or imported.
I create the table ORG_DATA_COPY and still the same error.
What am I doing wrong?
Thanks
Johnny