I want to import a dmp file using the following command

impdp c##user3/user3 full=y REMAP_SCHEMA=HR:c##user3 DIRECTORY=testdirec DUMPFILE=test.DMP TABLE_EXISTS_ACTION=REPLACE nologfile=y TRANSFORM=OID:N exclude=user ignore=y

but a got this error

Processing object type SCHEMA_EXPORT/TABLE/TABLE ORA-39083: Object type TABLE:"C##USER3"."TABLE1" failed to create with error: ORA-00959: tablespace 'HR_A' does not exist

Please any help would be appreciated!

CodePudding user response：

The tablespace that the source table was located in does not exist in the target database. You need to either create the HR_A tablespace or remap that tablespace to one that does exist.