NLS Character set changing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: NLS Character set changing

  1. #1
    Join Date
    Nov 2001
    Posts
    55

    Unhappy

    Hi,

    I am trying to change my oralce8i 8.1.7 installation on W2000 server character set from 'WE8ISO8859P1' to 'UTF8' when I am running 'alter database character set UTF8;' I am getting following error

    alter database character set UTF8
    *
    ERROR at line 1:
    ORA-12712: new character set must be a superset of old character set.

    But I need to change to UTF8. How can I do this?

    Could someone help me please

    Raj

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Want to do it officialy supported way, so your Oracle support contract remain walid? Then the only way is to do full export of your old database, create a brand new database with new character set and then import previously exported data.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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