| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | Gourish Singbal <gourish(at)gmail(dot)com> |
| Cc: | "Goulet, Dick" <DGoulet(at)vicr(dot)com>, Bradley Kieser <brad(at)kieser(dot)net>, Murugan G <murugan(dot)g(at)renaissance-it(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: migrating oracle table to PostgresQL |
| Date: | 2006-01-04 00:45:56 |
| Message-ID: | 20060104004556.GZ82560@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Dec 29, 2005 at 11:46:51AM +0530, Gourish Singbal wrote:
> ora2pg tool can be used to accomplish the migration from oracle to
> postgresql.
> download it from here...
> http://freshmeat.net/projects/ora2pg/
>
> The one in contib directory is an old version i guess.
>
> About clob, blob, and long columns in Oracle all become 'text' in
> postgresql.
Actually, you don't want to store binary (blob) data in a text field.
Use bytea instead, though it's limited to 1GB. You can also use large
objects, which go up to 2G.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-01-04 01:03:00 | Re: full data disk -- any chance of recovery |
| Previous Message | Jim C. Nasby | 2006-01-04 00:30:01 | Re: preventing deadlocks |