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
Check out Oracle Data migration assistant. I think it is available with 8i Enterprise Edition.
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:
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
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 email@example.com
I hope this can solve your problem :)
Does it converts the current data or just the new ( inserted ) data.
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
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.
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