By
Published: 19 Apr 2006
I have an export file created by EXPORT:V08.00.05 via conventional path. My system is running Oracle9i Enterprise Edition Release 9.0.1.1. When I tried to import the file, I got an error message:
Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
Export file created by EXPORT:V08.00.05 via conventional path
Warning: the objects were exported by REPOS_OWNER, not by you
import done in WE8ISO8859P1 character set and UTF8 NCHAR character set
import server uses WE8MSWIN1252 character set (possible charset conversion)
export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)
. importing REPOS_OWNER's objects into HR
IMP-00033: Warning: Table "XTSYS_EXPORT_OBJECTS" not found in export file
IMP-00033: Warning: Table "XTSYS_IMPORT_IRID_MAPPING" not found in export file
IMP-00033: Warning: Table "XTSYS_IMPORT_IVID_MAPPING" not found in export file
IMP-00033: Warning: Table "XTSYS_TABS_EXPORTED" not found in export file
IMP-00033: Warning: Table "XTSYS_RM$REPOSITORIES" not found in export file
Import terminated successfully with warnings.
Do I fix it?
The above are just warning messages and can be ignored. Your import did terminate successfully.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Continue Reading