10g Table to 7i Table???
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: 10g Table to 7i Table???

  1. #1
    Join Date
    Sep 2005
    Location
    Philippines
    Posts
    21

    10g Table to 7i Table???

    sir's/madam's

    is it possible to export 10g records to a 7i DB?

    its seems that dmp file is not compatible anymore ...
    are there procedures for this or its not possible?


    thanks...

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

  2. #2
    Join Date
    Sep 2005
    Location
    Philippines
    Posts
    21
    will SQLLDR works...??? 10g to 7i


    thanks

  3. #3
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    Using the Oracle7 SQL*Loader binary will work. Since you will loading a plain ASCII text file there are no issues in terms of compatibility.

  4. #4
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi.

    The documentation for 10g release 2 provides this matrix:

    http://download-uk.oracle.com/docs/c...htm#sthref2852

    It does not go as far back as Oracle 7, but the 8i executable would work with Oracle 7, which implies there could be an indirect route back, although I've never tried it.

    Cheers

    Tim...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  5. #5
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    That's possible!

    you need to have the oracle 7 exp executable to export the 10g data and imp using the oracle 7 executable. I did with Oracle 9i to 8 this way.

    How abt using DBlink, if the data needed from few tables?
    "What is past is PROLOGUE"

  6. #6
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    How abt using DBlink, if the data needed from few tables?
    I was looking into client interoperability for someone recently. According to Metalink note 207303.1 10g has never been certified with 7.3.4 (earliest version on Matrix). Going from a 10g client to a 7.3.4 server, you can expect an ORA-3134 if you try it (assuming the note is to be believed). 9.0.1 to 7.3.4 was once a certified combination, but nothing higher than that was ever supported.

  7. #7
    Join Date
    Sep 2005
    Location
    Philippines
    Posts
    21
    Thanks to all..... I will try to export
    the data of 10g using the 7i exp function....

  8. #8
    Join Date
    Sep 2005
    Location
    Philippines
    Posts
    21
    i inserted tnsnames.ora of the 10g in my unix 7i server
    but it seems it does not work since i am trying to connect it first
    via sqlplus to check if the exp module will connect to my 10g DB.
    am i missing something?

    ERROR: ORA-01034: ORACLE not available
    ORA-07318: smsget: open error when opening sgadef.dbf file.
    HP-UX Error: 2: No such file or directory

  9. #9
    Join Date
    Sep 2005
    Location
    Philippines
    Posts
    21
    while trying the dblink from 7i to 10g...i have an error
    ORA-03115

  10. #10
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi.

    The problem here is that connections from a 10g client to a 7.3.4 server are not supported. A database link works by make a client connection from one server to the other, hence your problem. I don't think this is a sensible route forward.

    Cheers

    Tim...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

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