Import into oracle 7.1
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Import into oracle 7.1

  1. #1
    Join Date
    Mar 2001
    Posts
    27

    Exclamation

    Hi gurus,

    How can i export a table from oracle 8.1.7 and import into 7.1.5.2.3.
    when i tried to import it is giving an error

    IMP-00010: not a valid export file, header failed verification
    IMP-00000: Import terminated unsuccessfully

    what could be the reason. pls guide me in this regard asap.
    Thanks in adv.

    muks

  2. #2
    Join Date
    Oct 2002
    Posts
    3
    Generally, you couldn't import tables from the high version database to low version database. The exported file's format might be different, and it will give you that error. One way to move data around on the network is to create dblink between these two databases, and just directly move data between them.


    Willy

  3. #3
    Join Date
    Sep 2000
    Posts
    305
    You can export. You just need to export the data of 8.1.7 through export utility of 7.1.5.2.3 server, create a service name of 8.1.7 on 7.1.5.2.3.

    for example exp username/password@sercice_name

    Hope this will help you
    Shailendra


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