Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    Shanghai , China
    Posts
    63

    Unanswered: ALTER DATABASE db1 CHARACTER SET WE8ISO8859P1

    I want to change my database character from UTF8 to WE8ISO8859P1
    I am not sure what I do is safe ,

    ALTER DATABASE db1 CHARACTER SET WE8ISO8859P1;
    ALTER DATABASE db1 NATIONAL CHARACTER SET WE8ISO8859P1;

    I heard the control file need to be recreated...
    Oracle is an ocean . I am just a little fish

  2. #2
    Join Date
    Jan 2003
    Location
    Vienna, Austria
    Posts
    102

    Re: ALTER DATABASE db1 CHARACTER SET WE8ISO8859P1

    I don't think you can migrate from UTF8 to WE8ISO8859Px.

    you can find Note:66320.1 in MetaLink:

    the interesting part is:
    --
    The ALTER DATABASE [NATIONAL] CHARACTER SET command will only work if the old character set is considered a binary subset of the new character set.
    ...
    otherwise you'll get
    ORA-12710: new character set must be a superset of old character set
    or
    ORA-24329: invalid character set identifier
    --
    in that case you might be able to solve the problem contacting oracle-support.

    I would suggest: do a full export, drop the DB, recreate the DB, do a full import.
    ^/\x

Posting Permissions

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