export database version 8.1.6 and import to 8.0.4 database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: export database version 8.1.6 and import to 8.0.4 database

  1. #1
    Join Date
    Oct 2000
    Posts
    250
    Hello All,
    I need the help from all of you regarding the export and import utility. I am going to export dmp file database versionis 8.1.6 and import to the database 8.0.4. I know this will cause the downward compatibility issues. But, is there other way to do it ? Please help me on this..


    Thanks

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    well, you will have to export AND import with the 8.0. binaries, but you should not lose anything if you do not use some exotic features of 8i

  3. #3
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    How is the COMPATIBLE parameter set in the init.ora of your 8.1.6 database?
    David Knight
    OCP DBA 8i, 9i, 10g

  4. #4
    Join Date
    Dec 1999
    Posts
    217
    The export has to be done using the higher version binaries. Thus, you will use the 8i export utility and import using the 8.0 export utility.

    Chintz

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by Chintz
    The export has to be done using the higher version binaries. Thus, you will use the 8i export utility and import using the 8.0 export utility.

    Chintz
    No, this will not work as 8.0 imp will not recognize the dump created by 8i exp.

    It should be done as pipo suggested: exp and imp has to be done with 8.0 binaries.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    May 2001
    Posts
    41
    You can do one thing.

    Install 8i in some other client Export from there to that Older version Database and before this Configure Net8 Easy config and test the connectivity....


    enjoy..

    RAMESH

  7. #7
    Join Date
    Dec 2000
    Posts
    255

    binary format export

    Hi

    I am also trying to export from 8.1.6 to 8.1.5 but there is problem of data format. Do I have to export in binary format
    if yes then how to do that

    Amol

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