Importing in 8.1.6 dump of 9.2
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Importing in 8.1.6 dump of 9.2

  1. #1
    Join Date
    Aug 2001
    Posts
    87

    Importing in 8.1.6 dump of 9.2

    Hi,

    We have to servers ,

    One for our financial which have 8.1.6 database server

    the 2nd is for sales system have 9.2.0.1 database server

    Currently i have to make interface so i have to export tables from the sales one and import it in the financial one.


    i did the export from sales but it give me error when i try to export it in the 8.1.6 one ,

    shal i have to execute the catexp of 8.1.6 in the 9.2 server and do the export again or there is a better solution


    Regards

  2. #2
    Join Date
    Dec 2001
    Posts
    203
    You took export from 9i DB and tried to export the same sump into 8.1.6.

    Try the following

    1. Take export from 9i(sales) DB using 9i EXP utility.
    2. From the same server (Sales 9i) import data into 8.1.6 using same 9i IMP utility.
    sumit

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    That is not correct. To go from 9i to 8i, use export of the 8i against the 9i database, and use import from 8i to import into the 8i database.

    If you wanted to go from 8i to 9i, you would use 8i export to create the dump file from the 8i database, and then use the 9i import to import into the 9i database.


    http://download-west.oracle.com/docs...mp.htm#1005557

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Could you post complete error message?
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  5. #5
    Join Date
    Aug 2001
    Posts
    87
    Hi,

    the error
    is IMP-00010 Not valid export file , header failed verification

    ,

    Regards

  6. #6
    Join Date
    Aug 2001
    Posts
    87
    Thanks stecal

    But can you tell me after i run the catexp.sql of 8i in the 9i server
    what command should i use,
    this is because after i execute the catexp.sql (8i) in the server of 9i, i exporting end with error of 904 ,

    Regards,

  7. #7
    Join Date
    Aug 2001
    Posts
    87
    Looking for seniors update,

    Any one face such a problem ,


    until now i cannot import from 9.2 and export it into 8.1.6


    Hope you to hands on this issue

  8. #8
    Join Date
    Jun 2003
    Location
    India
    Posts
    118
    1. Take export of 9i database using 8i export utility and
    do import in 8i database using 8i import utility.

    2.
    is IMP-00010 Not valid export file , header failed verification
    The error may be because if u have tranferred the dump file thru FTP then it should not be in binary mode it should be in ANSI.

    Thanks
    vishal sood
    OCP 8

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    ummm a dump file is a binary file

  10. #10
    Join Date
    Jun 2003
    Location
    India
    Posts
    118
    Dump file is not a Binery file, I mean to say is at the time of transferring file thru FTP, FTP may treat the file as Binary or ANSI.

    In case the dump file considered as binery then at the time of importing it may give the IMP-010 error.

    Thanks
    vishal sood
    OCP 8

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width