DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Conversion

  1. #1
    Join Date
    Sep 2000
    Posts
    56
    IS THERE ANY SOFT WARE AVAILABLE TO CONVERT ASCII CODED ORACLE DATABASE TO UNICODED ORACLE DATABASE.IF THERE ARE SOME TRANSLATORS AVAILABLE WHERE CAN WE FIND & WHAT IS THE PROCEDURE FOR THE TRANSLATION.ALL VIEWS ARE APPRECIATED.THANKS IN ADVANCE
    G.SURESH

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check out Oracle Data migration assistant. I think it is available with 8i Enterprise Edition.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Here is something that I lately found out.

    Changing the character set of a Database in Oracle 8i

    It is possible in 8i to drectly change the character set of a database. This can only be done, however, if the new character set is a strict superset of the original character set. For instance, according to 8.1.6 documentation, the conversion can be made from the US7ASCII character set to three other character sets which are strict supersets:

    current New

    US7ASCII WE8ISO8859P1
    US7ASCII ALT24UTFFSS
    US7ASCII UTF8

    to change the character set from US7ASCII to UTF8, execute the following,

    SVRMGRL> startup mount
    SVRMGRL> alter system enable restricted session;
    SVRMGRL> alter system set job_queue_process=0;
    SVRMGRL> alter system set aq_tm_process=0
    SVRMGRL> alter database open;
    SVRMGRL> alter database character set UTF8;
    SVRMGRL> shutdown immediate; -- or normal
    SVRMGRL> startup

    In the cases where the new character set is not a strict superset of the original character set, a full export/import is necessary.

    Tip cotributed by Adam Pope apope@dbadirect.com

    I hope this can solve your problem :)

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Sep 2000
    Posts
    56
    Does it converts the current data or just the new ( inserted ) data.
    Thanks
    Suresh


  5. #5
    Join Date
    Sep 2000
    Posts
    56
    I have got a table with 7 records.I guess this is in ASCII Format.How I will come to know in which format it is.Also I would like to know how to conver this 7 records to UNICODE
    ALL HELP IS APPRECIATED
    Thanks
    G.Suresh

  6. #6
    Join Date
    Nov 2000
    Posts
    212
    isn't it such thet after converting you must take care for string type columns (char, varchar2, ...) length:

    thier size is specified in bytes, if you convert to unicode (I believe Oracle use 2 bytes per Unicode char), then new data may not fit into old columns.


  7. #7
    Join Date
    Sep 2000
    Posts
    56
    Has any one got some suggestions how to convert ASCII formated data (The tables owned by a owner xyz) to convert into UNICODE(The same tables with that owner).If so please do send step by step procedure.Sorry for the trouble & all help is appreicated
    Thanks
    Suresh

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