| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Art Nicewick <art(dot)nicewick(at)ams(dot)com>, gilles(at)darold(dot)net |
| Cc: | ricardorsj(at)uol(dot)com(dot)br, pgsql-general(at)postgresql(dot)org, pgsql-general-owner(at)postgresql(dot)org, Thomas Lockhart <thomas(at)fourpalms(dot)org> |
| Subject: | Re: ora2pg fails on LONG object access in Catalog |
| Date: | 2002-04-10 17:58:28 |
| Message-ID: | 200204101758.g3AHwSH29906@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Gilles (ora2pg author), have you seen this?
Art Nicewick wrote:
>
> I recently used the program ora2pg to convert an Oracle 9i database to
> Postgress. i had a few problems.
>
> Data stored as /'' in oracle did could not be inserted into postgreSQL (The
> / had to be deleted)
>
> Line 1424 in ora2pm has a select statement that reads in a LONG field
> ("SEARCH_CONDITION") i changed this to ' '.
> Line 1315 alos had a LONG field in the SQL. ("DATA_
>
> I was able to get the program to work, However, I'm sure I'll hit problems
> as I need to convert elements (VIEWS, PROCS) that require this info.
>
> I think the problem has to do with the DBD:Oracle module support for 9i...
> Has anybody looked into this.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tycho Fruru | 2002-04-10 18:15:20 | Re: [HACKERS] [Fwd: AW: More UB-Tree patent information] |
| Previous Message | Michael Loftis | 2002-04-10 17:51:06 | Re: [HACKERS] [Fwd: AW: More UB-Tree patent information] |