DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Exp error exporting from 9i with 8i exp tool

  1. #11
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by Eldrik
    49 rows where count with status Invalid :( what should i do now?
    Recompile (ALTER . . . . . COMPILE) - if that fails debug (don't forget to shoot the developer responsible - Mr.H will tell you how to go about it)

    P.S. Oracle provide a proc \Rdbms\Admn\utlrp.sql to recompile what is needed.
    Last edited by DaPi; 04-21-2004 at 12:44 PM.

  2. #12
    Join Date
    Feb 2003
    Posts
    22
    I make an edit to my last posting !!

    Greetz
    Eldrik

  3. #13
    Join Date
    Feb 2003
    Posts
    22
    OK i did it there must be something wrong with the Oracle Client Patch 8.1.7.4.10 so export with 8i exp from 9i database perform this error.

    I tried it from a machine were exp tool version 8.1.7.0 is installed an everything works fine

    Is there anything known about problems with my Client Patchlevel?

    Greetz and thx for the quick answers.
    Eldrik

  4. #14
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Have a look at the doc on the patch (say) 8.1.7.4.13 - it will indicate if there was a subsequent fix - a Metalink search should tell you too.

  5. #15
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Try running catexp.sql and export again.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

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

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