+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 15
  1. 04-21-2004 11:37 AM #1
    Eldrik
    Eldrik is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 04-21-2004 11:40 AM #2
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    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.
    Reply With Quote Reply With Quote
  3. 04-21-2004 11:50 AM #3
    Eldrik
    Eldrik is offline Junior Member
    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
    Reply With Quote Reply With Quote
  4. 04-21-2004 12:13 PM #4
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    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.
    Reply With Quote Reply With Quote
  5. 04-21-2004 12:16 PM #5
    Eldrik
    Eldrik is offline Junior Member
    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?
    Reply With Quote Reply With Quote
  6. 04-21-2004 12:31 PM #6
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    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'
    Reply With Quote Reply With Quote
  7. 04-21-2004 12:33 PM #7
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    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.
    Reply With Quote Reply With Quote
  8. 04-21-2004 12:34 PM #8
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    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
    Reply With Quote Reply With Quote
  9. 04-21-2004 12:36 PM #9
    Eldrik
    Eldrik is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  10. 04-21-2004 12:40 PM #10
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    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!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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