8 Replies Latest reply: Jul 24, 2013 2:04 AM by tahasozgen RSS

    Issue Migrating Character Data Using a Full Export and Import

    tahasozgen

      Hi There;

      I have a database in my local machine that doesn't support Turkish characters. My NLS_CHARACTERSET is WE8ISO8859P1, It must be changed to WE8ISO8859P9 , since it supports full Turkish characters. I would like to migrate character data using a full export and import and my strategy is as follows:

      1- create a full export to a location in network,

      2- create a new database in local machine that it's NLS_CHARACTERSET is WE8ISO8859P9 (I would like to change NLS_LANGUAGE and NLS_TERRITORY by the way)

      3- and implement full import to newly created database.

       

      I 've implemented first step, but I couldn't implement the second step. I 've created the second step by using toad editor by clicking Create -> New Database but I can not connect the new database. I must connect new database in order to perform full import. How can I do this?

      Thanks in advance.

       

      Technical Details

      NLS_LANGUAGE.....................AMERICAN

      NLS_TERRITORY.....................AMERICA

      NLS_CURRENCY.....................$

      NLS_ISO_CURRENCY..............AMERICA

      NLS_NUMERIC_CHARACTERS    .,

      NLS_CHARACTERSET.............WE8ISO8859P1

      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 TZR

      NLS_TIMESTAMP_TZ_FORMAT..DD-MON-RR HH.MI.SSXFF AM TZR

      NLS_DUAL_CURRENCY............ $

      NLS_COMP...............................BINARY

      NLS_LENGTH_SEMANTICS.......BYTE

      NLS_NCHAR_CONV_EXCP........FALSE

      NLS_NCHAR_CHARACTERSET...AL16UTF16

      NLS_RDBMS_VERSION............10.2.0.1.0

      :