pROBLEMS WITH IMPORT

From: Hatzistavrou Giannis <j.hatzistavrou_at_telesoft.gr>
Date: Thu, 12 Oct 2000 17:06:17 +0300
Message-Id: <10647.119061@fatcity.com>

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:

1. 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. Received on Thu Oct 12 2000 - 09:06:17 CDT