Quick Links

migration issue

From:	윤태영 <tyyoon(at)daou(dot)co(dot)kr>
To:	questions(at)postgreSQL(dot)org
Subject:	migration issue
Date:	2008-06-27 04:14:30
Message-ID:	6350748.1214540071096.JavaMail.nsuser@mail.daou.co.kr
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

<html>
<head>
<META http-equiv=Content-Type content='text/html; charset=ks_c_5601-1987'>
<title>WINiPMail Mail</title>
<style>
BODY {font-family:굴림체, arial; font-size:9pt;}
P, td, li {font-family:굴림체, arial; font-size:9pt; margin-top:2px;margin-bottom:2px;}
</style>
</head>

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

Attachment	Content-Type	Size
unknown_filename	text/html	4.2 KB

Browse pgsql-general by date

	From	Date	Subject
Next Message	Dean Rasheed	2008-06-27 08:06:58	Re: what are rules for?
Previous Message	Tom Lane	2008-06-27 04:06:32	Re: ERROR: concurrent insert in progress