How to change Character set for oracle 8i databases
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: How to change Character set for oracle 8i databases

Hybrid View

  1. #1
    Join Date
    Jul 2005
    Location
    PUNE-INDIA
    Posts
    12

    How to change Character set for oracle 8i databases

    Hi All

    What is way to change CHARACTER SET for the database ?
    I have created Database in Oracle 8.1.6 with CHARACTER SET WE8ISO8859P1. Since this is 8-bit character set it will not support unicode charachetrs. I need the columns to accept NVACHAR / NCHAR values.

    So as to change CHARACTER SET, i already workout following process.

    1. SHUTDOWN IMMEDIATE; " BACKED UP DATABASE "
    2. STARTUP MOUNT;
    3. ALTER SYSTEM ENABLE RESTRICTED SESSION;
    4. ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 0;
    5. ALTER DATABASE OPEN;
    6. ALTER DATABASE CHARACTER SET AL16UTF16;

    SETP 6 HAS GIVEN FOLLOWING ERROR

    ALTER DATABASE CHARACTER SET AL16UTF16
    *
    ERROR at line 1:
    ORA-12712: new character set must be a superset of old character set

    Can any one help me out ? Do i need to recreate database again? what should be ideal character set for my scenario ?
    Regards
    Shrikant Pune
    shrikant23_datex@hotmail.com

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you need to recreate the database, but see Metalink note 66320.1
    Last edited by davey23uk; 09-08-2005 at 04:25 AM.

  3. #3
    Join Date
    Sep 2005
    Posts
    278
    Try this, WE8MSWIN1252 is a superset of WE8ISO8859P1

  4. #4
    Join Date
    Jul 2005
    Location
    PUNE-INDIA
    Posts
    12
    Try this, WE8MSWIN1252 is a superset of WE8ISO8859P1

    Still same error..
    Regards
    Shrikant Pune
    shrikant23_datex@hotmail.com

  5. #5
    Join Date
    Sep 2005
    Posts
    278
    have a look at the following link

    http://www.lazydba.com/oracle/0__31787.html

  6. #6
    Join Date
    Jul 2005
    Location
    PUNE-INDIA
    Posts
    12
    Hi

    I have drop database and recreated again with UTF8 character set but it is still not working for me. Can you tell me which is supported character set that will accept unicode characters.

    see the example below. I have logged in with sys as sysdba

    SQL> CREATE TABLE EMP (ENO NUMBER (10), NAME NVARCHAR2 (50) )
    2 TABLESPACE MASTERS_DATA;

    Table created.

    SQL> ALTER TABLE EMP MODIFY("NAME" DEFAULT 0);
    ALTER TABLE EMP MODIFY("NAME" DEFAULT 0)
    *
    ERROR at line 1:
    ORA-02262: ORA-%05d occurs while type-checking column default value expression


    SQL> DROP TABLE EMP;

    Table dropped.

    SQL> CREATE TABLE EMP (ENO NUMBER (10), NAME VARCHAR2 (50) )
    2 TABLESPACE MASTERS_DATA;

    Table created.

    SQL> ALTER TABLE EMP MODIFY("NAME" DEFAULT 0);

    Table altered.
    Regards
    Shrikant Pune
    shrikant23_datex@hotmail.com

  7. #7
    Join Date
    Sep 2005
    Posts
    278
    wat is the version of ur database???

  8. #8
    Join Date
    Jul 2005
    Location
    PUNE-INDIA
    Posts
    12
    8.1.6 Enterprise Edition..
    Regards
    Shrikant Pune
    shrikant23_datex@hotmail.com

  9. #9
    Join Date
    Sep 2005
    Posts
    278
    Did u set the registry NLS_LANG to AMERICAN_AMERICA

    OR U can use AL24UTFFSS for National Character Set
    Last edited by tabreaz; 09-08-2005 at 11:41 AM.

  10. #10
    Join Date
    Sep 2005
    Posts
    278
    this link maybe very much helpfull for u

    http://www.oracle.com/technology/tec...code_10gR2.pdf

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width