Database DataWarehousing (MOSC)

MOSC Banner

ORA-19722 Error during the import of Transportable Tablespaces

edited Jan 14, 2010 1:30AM in Database DataWarehousing (MOSC) 2 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center