thanx a lot for your info' Regis.
i need to calculate the exact time taken for IMP.
the source and target char. set is JA16SJIS,whereas i have UTF8 on test Database.
So thought of changing it to JA16SJIS.
okif there is no other option ...let me re-create the DB.
p
Guys,
Existing setup:
NLS_CHARACTERSET= UTF8
NLS_NCHAR_CHARACTERSET = UTF8
i need to change both to JS16SJIS.
1# is it possible ? if so , how ?
2# which is the super set among these two ?
the ENV is 9.2. on win2k.
TIA.
Jp.
--
Please see the official ORACLE-
Why first don't you try with character scanner utility
if you have 8.1.7 ?. Just to see which approach has to
be taken. In the end you would find whether you can
use or not alter database character set command or
not.
Regards.
--- Ruth Gramolini <[EMAIL PROTECTED]> wrote:
> If the character set y
If the character set you are going to is a superset of the old characterset
then you won't have to do anything. If it is not, you will have to export
and import the database to have the new characterset be good for all ot the
data.
HTH,
Ruth
- Original Message -
To: "Multiple recipients
Hi,
I am putting this question again but we need little more input...
We are currently using database character set WE8ISO8859P1.
As we are storing unicode data using NVARCHAR2 ..and we are having some
problem with ODBC hadling NVARCHAR2...
So we decided to move to character set UTF8 so that
