Error
Error Code: ORA-29347

Oracle Tablespace Mismatch ORA-29347

📦 Oracle Database
📋

Description

The ORA-29347 error indicates a mismatch between tablespaces specified in the import command and the tablespaces present in the transportable set. This typically occurs during transportable tablespace operations when the tablespace list is either incomplete or contains incorrect entries.
💬

Error Message

ORA-29347: Tablespace name validation failed - failed to match tablespace ' string '
🔍

Known Causes

2 known causes
⚠️
Missing Tablespace in Import List
A tablespace within the transportable set is not included in the TABLESPACES list used during the import operation. ⚠
⚠️
Tablespace Not in Transportable Set
A tablespace specified in the TABLESPACES list is not actually part of the transportable set being imported. ⚠
🛠️

Solutions

Coming Soon

Detailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:

General Troubleshooting Tips

  • Check the error message carefully for specific details
  • Review recent changes that might have caused the error
  • Search for the exact error code in the official documentation
  • Check log files for additional context
  • Try restarting the application or service

Find Help

Stack Overflow Google Search Official Docs