Home > Ask the Oracle Experts > Database Backup and Recovery Questions & Answers > Can I import into Oracle 9i with imp.exe version 10g?
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Can I import into Oracle 9i with imp.exe version 10g?

Brian Peasland EXPERT RESPONSE FROM: Brian Peasland

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site


Oracle tips, scripts, and expert advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 09 July 2007

My customer has Oracle 10g database, and my test database is Oracle 9i. My customer made an export of data with exp.exe version 10. I can't make an import with my imp.exe version 9 because it is a lower version.

So, I try to import data (that was exported with exp.exe version 10) with imp.exe version 10 into my 9i database, and I get an error:

IMP-00058: ORACLE error 6550 encountered
ORA-06550: line 1, column 33:
PLS-00302: component 'SET_NO_OUTLINES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
IMP-00000: Import terminated unsuccessfully

Is it OK that I try to import data into database version 9i with imp.exe version 10g? Or should I tell my customer to make an export with exp.exe version 9i?


>
EXPERT RESPONSE
When crossing major versions of Oracle, always export with the lower version's export utility. The error above is common when trying to import a 10g dump file into an Oracle 9i database. At this point, you have two options. One, have your client use the 9i exp utility. Two, create a 10g database on your end, import the dump file. Then export on your end with your 9i exp utility before importing into your 9i database.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


RELATED CONTENT
Database Backup and Recovery
How to recover a control file
The USING BACKUP CONTROLFILE clause in Oracle commands
Backup and recoveries of Oracle RAC 10gR2
How to use the OPatch Utility in Oracle
Backup and recovery of Oracle 10g with forgotten admin password
How to get history of modified data from Oracle databases
Export dump with files larger than 2 GB
What is Unix shell scripting?
Performing a backup with table locks
How to move data faster with a database link

Oracle database backup and recovery
Oracle 11g: Backup and recovery concepts
Weighing remote database administration pros and cons takes care
Data retention policy for Oracle DBAs: When to "trash" your data
Case study: Oracle RMAN improves backup and recovery efficiency in a multi-platform, multi-application environment
How do I do that in Oracle?
Oracle and the rise of the virtual machine
Oracle 11g data compression
Oracle OpenWorld 2007 Special Report
Hierarchical storage management for database growth, part 1
One datafile not accessible
Oracle database backup and recovery Research

Oracle database export, import and migration
Oracle and SQL Server: BFF?
Oracle as data integrator
Importing from Oracle 8i to Oracle 10g
Export schemas of users of database
Exp/imp for complex cross-platform migration and upgrade
How to export data by date in Oracle
Large data migration from XML database to Oracle 10g
IMP-00017 error message with Oracle import
Can't open database after failed backup export
LOB tables missing with exp/imp move of schema

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

HomeNewsTopicsTipsAsk the ExpertsWebcastsWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2003 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts