Re: pROBLEMS WITH IMPORT

Go to Metalink and look for these papers: 9842.1
10595.1 'Export/Import and NLS Considerations' 60134.1 'Frequently Asked Questions'

These should help.
Ruth

• Original Message ----- From: "Hatzistavrou Giannis" <j.hatzistavrou_at_telesoft.gr> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, October 12, 2000 10:37 AM Subject: pROBLEMS WITH IMPORT

> 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
Received on Thu Oct 12 2000 - 09:56:26 CDT