DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Export Problem

  1. 01-31-2002, 02:47 PM #1
    sln81
    sln81 is offline Member
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    I'm trying to export a user schema. When I do it from the client, I'm ending up with errors. Errors are as follows

    . . exporting table T1
    EXP-00008: ORACLE error 904 encountered
    ORA-00904: invalid column name
    . . exporting table T2
    EXP-00008: ORACLE error 1003 encountered
    ORA-01003: no statement parsed
    . . exporting table T3
    EXP-00008: ORACLE error 904 encountered
    ORA-00904: invalid column name
    . . exporting table T4
    EXP-00008: ORACLE error 1003 encountered
    ORA-01003: no statement parsed
    ...
    ...
    ...

    But, when I export from the server, the export is completed successfully.

    Can you tell me why this is happening?
    Reply With Quote Reply With Quote
  2. 02-01-2002, 01:37 AM #2
    grjohnson's Avatar
    grjohnson
    grjohnson is offline Senior Advisor
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Are the export utilities on the CLient the same as the server. You may have install the 8.1.6 on the client, but have 8.1.7 on the server.

    Cheers
    OCP 8i, 9i DBA
    Brisbane Australia
    Reply With Quote Reply With Quote
  3. 02-01-2002, 10:43 AM #3
    sln81
    sln81 is offline Member
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    Its actually the other way. I have 8.1.6 on the server and 8.1.7 on the client
    Reply With Quote Reply With Quote
  4. 02-01-2002, 11:00 AM #4
    kgb
    kgb is offline Advisor
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    You can import from 8.1.6 client to 8.1.7 server but not backward.

    Originally posted by sln81
    Its actually the other way. I have 8.1.6 on the server and 8.1.7 on the client
    Best wishes!
    Dmitri
    Reply With Quote Reply With Quote
  5. 02-01-2002, 11:06 AM #5
    sln81
    sln81 is offline Member
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    First of all I'm trying to export, so that I want to import into 8.1.7 database
    Reply With Quote Reply With Quote
  6. 02-01-2002, 11:10 AM #6
    mike73
    mike73 is offline Senior Member
    Join Date
    Aug 2001
    Posts
    390
    when you have two Oracle Version on the same box, Oracle will automatically use the newer version executeable, in your case, Oracle was using exp.exe on 8.1.7 and try to export the 8.1.6 database.

    You have to specify and tell Oracle to use Oracle 8.1.6 utilities instead when you got the dump file and use imp utility to import to your database and you won't have problem.

    good luc k
    Reply With Quote Reply With Quote
  7. 02-01-2002, 11:16 AM #7
    sln81
    sln81 is offline Member
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    Let me put my question straight forward.

    Can I use 8.1.7 export utility on 8.1.6 database?
    Reply With Quote Reply With Quote
  8. 02-01-2002, 12:33 PM #8
    kgb
    kgb is offline Advisor
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    You can not use import/export THERE IS NO BACWARD compatibility in this case, because EXPORT/IMPORT views are different with 8.1.6.
    When 8.1.6 created it did not know even about version 8.1.7.

    May you will be able to manage it but I could not.

    Originally posted by sln81
    Let me put my question straight forward.
    Can I use 8.1.7 export utility on 8.1.6 database?
    Best wishes!
    Dmitri
    Reply With Quote Reply With Quote
  9. 02-01-2002, 12:41 PM #9
    mike73
    mike73 is offline Senior Member
    Join Date
    Aug 2001
    Posts
    390
    you can't use 8.1.7 utility to export 8.1.6 database


    NOOOOOOOOOOOOOOOOOOOOOOOOOOO


    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width