-
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 remember when this place was cool.
-
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
I remember when this place was cool.
-
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'
-
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.
-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|