migration issue - Mailing list pgsql-general

<dl><dt style="line-height:150%;"><font face="Fixedsys">Dear Postgresql<br /><br />Hi! How are things going? I'm tae
youngin Korea<br /><br />I'm writing to ask you a favor.<br /><br />Now, we are taking a migration testing about Oracle
toenterprisedb</font><dt style="line-height:150%;"><font face="Fixedsys">(I know, It's not Postgresql issue, but I
reallywant to help anyone about this)<br /><br />Then we've got some problems on migration.<br /><br />So, if you can
helpus, give us your reply.<br />=====================================================================<br />Install :
enterprisedb8.3 (Postgres Plus Advanced Server)<br /><br />Test WAS : Tomcat 5.5<br /><br />Using tool : Migration
Studio<br/><br />Problems<br />1. test db -> Oracle815 : while using migration studio, error occurs<br /><br />"
Error: Protocol violation" ...then migration studion stoping<br /><br />2. test db -> oracle9 : while using
migrationstudio, problem occurs<br /><br />[install : euc_kr, create database : euc_kr]<br /><br />"Error : "UTF8" In
encondingthere is a character it's not available (GUI mode)"<br /><br />and desc of table which is a problem table<br
/><br/>"Error : In encoding "EUC_KR" there is a character it's not available (Command mode)"<br /><br />3. Common
utilityis not operation or make error.<br /><br />(1) hint option is not apply normally in enterprisedb<br /><br
/>example: it should be descending but it make ascending<br /><br />--> select /*+ index_desc(table_name table_idx)
*/<br/><br />user_id, title<br /><br />from table_name;<br /><br />(2) when it use substrb, it occur error<br /><br
/>example: column type[varchar2](enterprisedb -> character varying) use substrb<br /><br />data_type(byte_type) is
changing<br/><br />예) insert into table_name (title) values (substrb(?, 1, 60));<br /></font><dt
style="line-height:150%;"><fontface="Fixedsys"> </font><dt style="line-height:150%;"><font face="Fixedsys">:: "error:
column"title" is character varying but expression type is bytea"<br /><br />Those are some problems when we've
tested.<br/><br />Error message came in Korean, and I translated those message into English.<br /><br />So, if you
complicatesomething or don't understand, please contact me.<br /><br />We look froward to your favorable reply.<br
/><br/>Cordially yours.<br /></font><dt style="line-height:150%;"><font face="Fixedsys"> </font><dt
style="line-height:150%;"><fontface="Fixedsys">P.S : Just I'm wondering</font><dt style="line-height:150%;"><font
face="Fixedsys"> </font><dtstyle="line-height:150%;"><font face="Fixedsys">Did you have a similar problem when you get
migrationissue Postgresql from Oracle??</font><dt style="line-height:150%;"><font face="Fixedsys"
size="3">=================================================</font><dtstyle="line-height:150%;"><font face="Fixedsys"
size="3">Tae-YoungYoon</font><dt style="line-height:150%;"><font face="Fixedsys" size="3">Engineer</font><dt
style="line-height:150%;"><fontface="Fixedsys" size="3">Special business Dept.</font><dt
style="line-height:150%;"><fontface="Fixedsys" size="3">Daou Tech Co, Ltd.</font><dt style="line-height:150%;"><font
face="Fixedsys"size="3">Email : tyyoon@daou.co.kr</font><dt style="line-height:150%;"><font face="Fixedsys"
size="3">Fax: +82 2 3450 4748</font><dt style="line-height:150%;"><font face="Fixedsys" size="3">DID : +82 2 3450
4858</font><dtstyle="line-height:150%;"><font face="Fixedsys" size="3">Mobile : +82 11 1740 7510</font><dt
style="line-height:150%;"><fontface="Fixedsys"
size="3">==================================================</font></dl><imgborder="0" height="0"
src="http://winipmail.daou.co.kr:80/servlet/ReadConfirmer?confirmid1e91-11ac83abff5-720e-mail.daou.co.kr"width="0" />