Try setting
NLS_LANG Parameter before import..
- Hatzistavrou Giannis <j.hatzistavrou_at_telesoft.gr>
wrote:
> Dear All,
>
>
> Oracle : 8.1.5
> Platform: NT
>
> I received an export file of a test db which I need
> to import it into an
> instance I have created myself:
> When I use the import command I got the followin
> errors:
>
> export file created by EXPORT:v08.01.05 via
> conventional path
> import done in WE8DEC character set and EL8ISO8859P7
> NCHAR character set
> import server uses EL8ISO8859P7 character set
> (possible charset conversion)
> export server uses WE8DEC NCHAR character set
> (possible ncharset conversion)
>
> and it ends there:
>
> a) select * from nls_session_parameters;
>
> NLS_LANGUAGE AMERICAN
> NLS_TERRITORY AMERICA
> NLS_CURRENCY $
> NLS_ISO_CURRENCY AMERICA
> NLS_NUMERIC_CHARACTERS .,
> NLS_CALENDAR GREGORIAN
> NLS_DATE_FORMAT DD-MON-YY
> NLS_DATE_LANGUAGE AMERICAN
> NLS_SORT BINARY
> NLS_TIME_FORMAT HH.MI.SSXFF AM
> NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF
> AM
> NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM
> TZH:TZM
> NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF
> AM TZH:TZM
> NLS_DUAL_CURRENCY $
> NLS_COMP BINARY
>
> b) select * from nls_database_parameters;
>
> NLS_LANGUAGE AMERICAN
> NLS_TERRITORY AMERICA
> NLS_CURRENCY $
> NLS_ISO_CURRENCY AMERICA
> NLS_NUMERIC_CHARACTERS .,
> NLS_CHARACTERSET EL8ISO8859P7
> NLS_CALENDAR GREGORIAN
> NLS_DATE_FORMAT DD-MON-RR
> NLS_DATE_LANGUAGE AMERICAN
> NLS_SORT BINARY
> NLS_TIME_FORMAT HH.MI.SSXFF AM
> NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF
> AM
> NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM
> TZH:TZM
> NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF
> AM TZH:TZM
> NLS_DUAL_CURRENCY $
> NLS_COMP BINARY
> NLS_NCHAR_CHARACTERSET EL8ISO8859P7
> NLS_RDBMS_VERSION 8.1.6.0.0
>
> c)select * from nls_instance_parameters;
>
>
> NLS_LANGUAGE AMERICAN
> NLS_TERRITORY AMERICA
> NLS_SORT
> NLS_DATE_LANGUAGE
> NLS_DATE_FORMAT
> NLS_CURRENCY
> NLS_NUMERIC_CHARACTERS
> NLS_ISO_CURRENCY
> NLS_CALENDAR
> NLS_TIME_FORMAT
> NLS_TIMESTAMP_FORMAT
> NLS_TIME_TZ_FORMAT
> NLS_TIMESTAMP_TZ_FORMAT
> NLS_DUAL_CURRENCY
> NLS_COMP
>
> it does not help if i explicitly set
> nls_characterset and
> nls_nchar_characterset to WE8DEC.
>
> Which way do I have to proceed in order to make
> import work?
>
> Thanks
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Hatzistavrou Giannis
> INET: j.hatzistavrou_at_telesoft.gr
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Ashish
Toronto, Canada
Received on Thu Oct 12 2000 - 10:02:44 CDT
