'ORA-00959: tablespace 'X' does not exist while running impdp command
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!
Solution 1:[1]
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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | pmdba |