In this post, you’ll learn more about the Oracle ErrorORA-29347: Tablespace name validation failed – failed to match tablespace ‘string’ with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-29347: Tablespace name validation failed – failed to match tablespace ‘string’
Reason for the Error ORA-29347: Tablespace name validation failed – failed to match tablespace ‘string’
The system failed to match the referred tablespace. There are 2 cases that this may happen. (1) This tablespace is in the transportable set, but it is not specified in the TABLESPACES list of the import command line option, assuming that TABLESPACES is specified. (2) This tablespace is in the TABLESPACES list, but it is not in the transportable set.
How to fix the Error ORA-29347: Tablespace name validation failed – failed to match tablespace ‘string’ ?
You can fix this error in Oracle by following the below steps
Retry the operation with the correct TABLESPACES list.