This discussion is archived
8 Replies Latest reply: Jul 24, 2013 12:04 AM by 966347 RSS

Issue Migrating Character Data Using a Full Export and Import

966347 Newbie
Currently Being Moderated

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

:

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points