Error ORA-19722 When Trying to Import (IMP) Transportable Tablespaces
(Doc ID 1068049.6)
Last updated on NOVEMBER 07, 2023
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 8.1.5.0 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.
Symptoms
When you try to import a transportable tablespace the following errors occur:
Export file created by EXPORT:V08.01.05 via conventional path
About to import transportable tablespace(s) metadata...
import done in US7ASCII character set and US7ASCII NCHAR character set
. importing SYS's objects into SYS
IMP-00017: following statement failed with ORACLE error 19722:
"BEGIN sys.dbms_plugts.checkDatafile(NULL,571837179,4,512,11,4,4194302,1,4"
"40013,440091,1,16777218,NULL,NULL,NULL); END;"
IMP-00003: ORACLE error 19722 encountered
ORA-19722: datafile //datafile.dbf is an incorrect version
ORA-06512: at "SYS.DBMS_PLUGTS", line 1600
ORA-06512: at line 1
About to import transportable tablespace(s) metadata...
import done in US7ASCII character set and US7ASCII NCHAR character set
. importing SYS's objects into SYS
IMP-00017: following statement failed with ORACLE error 19722:
"BEGIN sys.dbms_plugts.checkDatafile(NULL,571837179,4,512,11,4,4194302,1,4"
"40013,440091,1,16777218,NULL,NULL,NULL); END;"
IMP-00003: ORACLE error 19722 encountered
ORA-19722: datafile //datafile.dbf is an incorrect version
ORA-06512: at "SYS.DBMS_PLUGTS", line 1600
ORA-06512: at line 1
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! |