TTS IMPORT FAILING WITH "ORA-10632: INVALID ROWID"
(Doc ID 3053340.1)
Last updated on OCTOBER 26, 2024
Applies to:
Gen 2 Exadata Cloud at Customer - Version N/A and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database - Enterprise Edition - Version 19.22.0.0.0 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
TTS import is failing with the error - ORA-10632: Invalid rowid, as below:
Requirement was to take copies of production DB to DEV or TEST DB's. TTS is used for this as the DB size is in TB's and TTS faster.
The existing PDB is dropped, PDB is cloned from the PROD DB and a TTS import is done. This process has been done multiple times and has always worked.
However, when the clone is being done from one DEV DB to another DEV DB, then this is failing with "ORA-10632: INVALID ROWID"
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |