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

Yeah I have a solution.

Teach you database to speak english!!

Babblefish broken today, need translation.

MH

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

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

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?

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'

Quote:

---

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

Quote:

---

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 ;)

Quote:

---

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

Quote:

---

Originally posted by Mr.Hanky
Teach you database to speak english!!

---

It's not even good Schweizerdeutsch: "durchgef³hrt" u.s.w. Huh!

Quote:

---

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.

I make an edit to my last posting !!

Greetz
Eldrik

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

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.

Try running catexp.sql and export again.