ORA-19722 Error during the import of Transportable Tablespaces
Hello All,
Environment : AIX 5.3.0.0 5300-09 (64-bit)
RDBMS: 11.1.0.7.0
We are getting the following error message during import of transportable tablespaces.
We refreshed this database from production, steps ...
1. We made the transportable tablespaces read-only.
2. We took an export of the transportable tablespaces.
3. We changed them back to read write mode.
4. Shutdown the database.
5. Refresh all the datafiles with production files (except the transportable files)
6. Import the transportable tablespace back into the database.
Username:
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V11.01.00 via conventional path
Environment : AIX 5.3.0.0 5300-09 (64-bit)
RDBMS: 11.1.0.7.0
We are getting the following error message during import of transportable tablespaces.
We refreshed this database from production, steps ...
1. We made the transportable tablespaces read-only.
2. We took an export of the transportable tablespaces.
3. We changed them back to read write mode.
4. Shutdown the database.
5. Refresh all the datafiles with production files (except the transportable files)
6. Import the transportable tablespace back into the database.
Username:
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V11.01.00 via conventional path
0