Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Import Export error...need help (newbie)

Posted on 2003-11-03
4
1,715 Views
Last Modified: 2008-02-01
I'm a web developer and use oracle for sqlplus commands.  However, the need has arisen for me to import data set up on a different system.  Basically, the following is happening:

imp dbuser/pass@db file=thexport.dmp

yields:
IMP-00010: not a valid export file, header failed verification
IMP-00021: operating system error - error code (dec 2, hex 0x2)
IMP-00000: Import terminated unsuccessfully

Checking the versions of both, at the top of the .dmp file I see:
^C^CgEXPORT:V08.01.06F

and when I start the import I see:
Import: Release 8.0.5.1.0

Is this simply a version conflict?  We have an oracle 9i db running, but maybe the import/export wasn't upgraded in the process?  

0
Comment
Question by:ldsnerd
4 Comments
 
LVL 23

Accepted Solution

by:
seazodiac earned 50 total points
ID: 9673625
when you exp/imp the database, you DO need to watch for the imp/exp tool version compatibility.

the simple rule of thumb when you do exp/imp from the different version of databases,
you should always use the LOWER version of tool to do the IMP/EXP.
0
 

Expert Comment

by:mdba
ID: 9674216
There is also another possibility.  If the version was incorrect, then it would be likely that this would be the error.  Did you ftp the file over to the other system as ascii or binary.  It should have been binary.  Oracle will bark if it was not the right type.  
0
 

Expert Comment

by:sboobalan
ID: 9678154
I'm trying to import on different machine on same version of oracle
, same version of OS.


For one table the import failed whith :

IMP-00058: ORACLE error 1438 encountered
ORA-01438: value larger than specified precision allows for this column
IMP-00018: partial import of previous table completed: 17600 imported
0
 

Expert Comment

by:psmuruga
ID: 9975062
Hi there
check the table's column size.. error look number's decimal precision of a column in the table..
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question