Oracle Import

0 pts.
Tags:
Database
DB2
Oracle
I am trying to do export from vax alpha oracle 8.1 to Linux Oracle 9i I am getting following error in Import on Linux Oracle 9i machine IMP-00010 : not a valid export file , header failed verification. Can you suggest something? I thought earlier may be file not in binary or got corrupted in email etc. But I have checked the file transfer and I am sure there is not any problem in transfer Thanks.
ASKED: October 26, 2005  3:28 PM
UPDATED: October 31, 2005  10:38 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,
Can you try compiling following 2 files logging as sys.
$ORACLE_HOME/rdbms/admin/dbmsread.sql
$ORACLE_HOME/rdbms/admin/prvtread.plb

I am not very sure that this will work. But it may resolve the issue.

Regards.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Defaulters
    Hi, Will You specify more About export command you give. Basiclly which type of export you are trying on. Thanks
    0 pointsBadges:
    report
  • DaveInAZ
    Without actually knowing much about potential problems transferring data between those two particular servers, it sounds like a classic version compatibility issue, to me. Assuming there were no errors during the export, I'd try importing the resulting file back into the 8.1 server, to make sure it's a valid export, from that server's point of view. If you can import that file back in successfully, I'd try exporting to a neutral format, such as CSV, and seeing if that imports successfully on the 9i box. If that works, it's probably not an incompatibility between the OS's, so you can focus on the import/export settings in Oracle. It may be necessary to set a "backward compatibility flag" of some sort on the import.
    0 pointsBadges:
    report
  • Singhbb
    [...] Original Address: http://itknowledgeexchange.techtarget.com/itanswers/oracle-import/ (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following