Exp error exporting from 9i with 8i exp tool
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

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

  1. #1
    Join Date
    Feb 2003
    Posts
    22

    Exp error exporting from 9i with 8i exp tool

    Hi,

    iam getting this error when i try to export from 9i with 8i export tool for a later import in a different 8i database:

    C:\oracle\ora81\bin>exp Frank/pass@ora02 FILE=C:\frank9i_8i_exp.dmp

    Export: Release 8.1.7.4.1 - Production on Mi Apr 21 17:15:23 2004

    (c) Copyright 2000 Oracle Corporation. All rights reserved.


    Verbunden mit: Oracle9i Release 9.2.0.1.0 - Production
    JServer Release 9.2.0.1.0 - Production <
    Exportieren in WE8ISO8859P1-Zeichensatz und UTF8-NCHAR-Zeichensatz durchgef³hrt
    . Prozedurale Pre-Schema-Objekte und -Aktionen werden exportiert
    . Fremdfunktions-Bibliotheksnamen f³r Benutzer Frank werden exportiert

    . Objekttypdefinitionen f³r Benutzer Frank werden exportiert
    Frank Objekte werden gleich exportiert ...
    . Datenbank-Links werden exportiert
    . Sequenzzahlen werden exportiert
    . Clusterdefinitionen werden exportiert
    . Tabellen von Frank werden gleich exportiert ... ³ber 'Conventional P
    ath'
    EXP-00008: ORACLE-Fehler 604 gefunden
    ORA-00604: Fehler auf rekursiver SQL-Ebene 1
    ORA-06502: PL/SQL: numerischer oder Wertefehler: Zeichenfolgenpuffer zu klein
    ORA-06512: in Zeile 8
    ORA-00904: Ung³ltiger Spaltenname
    EXP-00000: Der Export-Vorgang endete mit Fehlern

    Does anyone got a sollution?

    Greetz
    Eldrik

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    Yeah I have a solution.

    Teach you database to speak english!!

    Babblefish broken today, need translation.

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Feb 2003
    Posts
    22
    I hope the translator got it right, sad but true the format is lost wihtin the translaiton :(

    Export: Release 8.1.7.4.1 - Production on Mi April 21 17:15:23 2004(C) Copyright 2000 Oracle corporation. All rights reserved.
    Connected with: Oracle9i release 9.2.0.1.0 - Production JServerrelease 9.2.0.1.0 - Production
    < exporting in WE8ISO8859P1-Zeichensatzand UTF8-NCHAR-Zeichensatz durchgef³hrt.
    Procedural Pre patternobjects and actions are exported.
    Foreign function library names f³ruser franc are exported. Definitions of type of object f³r user franc exports franc ofobjects equivalent exported....
    Data base on the left of are exported.
    Sequence numbers are exported.
    Cluster definitions are exported.
    Tables of franc equivalent exported...
    ³ber \\\'Conventional P ath \ \\
    ' EXP-00008: ORACLE error 604 found
    ORA-00604: Error on recursiveSQL level 1 ORA-06502: PL/SQL: numerically or value errors:
    Charactersequence buffer too small
    ORA-06512: in line 8
    ORA-00904: Ung³ltigercolumn name
    EXP-00000: The export procedure ended with errors

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    I am not certain on this one but I think you are trying to export invalid procedures. Can you re-compile them?

    Anyone else see this error before?

    MH
    I remember when this place was cool.

  5. #5
    Join Date
    Feb 2003
    Posts
    22
    the export stops by exporting the tables of user Frank! Does my client software update to 8.1.7.4 can have a deal with it?

  6. #6
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    I think you might be right Mr.H: Ungültiger Spaltenname = Incorrect/Illegal column name. It could be coming from view perhaps? They seem to get exported before the procs.

    Eldrik, look in DBA_OBJECTS for rows with STATUS = 'INVALID'

  7. #7
    Join Date
    Jan 2001
    Posts
    3,131
    Originally posted by DaPi
    I think you might be right Mr.H: Ungültiger Spaltenname = Incorrect/Illegal column name. It could be coming from view perhaps? They seem to get exported before the procs.

    Eldrik, look in DBA_OBJECTS for rows with STATUS = 'INVALID'
    He is my German consultant, has a slight drinking problem but we don't hold it against him.



    MH
    I remember when this place was cool.

  8. #8
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by Mr.Hanky
    He . . . has a slight drinking problem but we don't hold it against him.



    MH
    The problem is getting enough

  9. #9
    Join Date
    Feb 2003
    Posts
    22
    Originally posted by DaPi
    I think you might be right Mr.H: Ungültiger Spaltenname = Incorrect/Illegal column name. It could be coming from view perhaps? They seem to get exported before the procs.

    Eldrik, look in DBA_OBJECTS for rows with STATUS = 'INVALID'
    49 rows where count with status Invalid :( what should i do now?

    Edit:

    I compiled 48 objects to be valid only one procedure does not go in a valid status, i kicked it out of the database but still the same error!

    Greetz
    Eldrik
    Last edited by Eldrik; 04-21-2004 at 12:43 PM.

  10. #10
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by Mr.Hanky
    Teach you database to speak english!!
    It's not even good Schweizerdeutsch: "durchgef³hrt" u.s.w. Huh!

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