-
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
-
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!
-
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!
-
Does it converts the current data or just the new ( inserted ) data.
Thanks
Suresh
-
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
-
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
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|