Oracle 9i-Problem s Export

Zdraveite
Opitvam se da napravia pylen export na baza danni (Oracle 9.2.0.1.0 ) i poluchavam slednoto:

EXP system/manager@database PARFILE='exp_parfile.txt'

Export: Release 9.2.0.1.0 - Production on Fri May 14 14:42:21 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 6552 encountered
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-553: character set name is not recognized
EXP-00000: Export terminated unsuccessfully

Niakoi moje li da pomogne ? Blagodaria predvaritelno

character set-овете не са ти нещо в ред

кажи NLS_LANG-a на базата и на клиента, щото май не даваш пълните съобщения

NLS Database Parameters

NLS_CALENDAR GREGORIAN
NLS_CHARACTERSET WE8ISO8859P1
NLS_COMP BINARY
NLS_CURRENCY $
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_DUAL_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_LANGUAGE AMERICAN
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CONV_EXCP FALSE
NLS_NUMERIC_CHARACTERS .,
NLS_RDBMS_VERSION 9.2.0.1.0
NLS_SORT BINARY
NLS_TERRITORY AMERICA
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR


v nachaloto NLS_NCHAR_CHARACTERSET beshe AL16UTF16
posle go promenih na WE8ISO8859P1 , pak Export-a ne raboteshe

sega syobshtenieto e v nachaloto na exporta e :
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

i pak se poluchava slednoto:

. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 6552 encountered
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-553: character set name is not recognized
EXP-00000: Export terminated unsuccessfully

иди и си сетни в регистрито NLS_LANG да е същото като това на базата AMERICAN_AMERICA.WE8ISO8859P1. Сетваш го на този компютър, от който пускаш експорт клиента си. Така експорта ще мине, после ако искаш си върни старата стойност. По този начин няма да има implicit conversion, дори и да дава, че е възможно.
В command prompt сетване на environment variable не става, затова го направи през регистрито.