| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Gene Poole *EXTERN*" <gene(dot)poole(at)macys(dot)com>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Cc: | "jpdsys2(at)comcast(dot)net" <jpdsys2(at)comcast(dot)net>, "etpoole60(at)comcast(dot)net" <etpoole60(at)comcast(dot)net>, "jpdsys7(at)comcast(dot)net" <jpdsys7(at)comcast(dot)net>, "etpoole64(at)gmail(dot)com" <etpoole64(at)gmail(dot)com>, "etpoole6465(at)gmail(dot)com" <etpoole6465(at)gmail(dot)com> |
| Subject: | Re: Will This Work? |
| Date: | 2013-09-13 06:46:25 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B17C1CFDF@ntex2010a.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Gene Poole wrote:
> If I wanted to move from Oracle to PostgreSQL is it possible to use a Oracle export
> DMP file to load the PostgreSQL database?
Oracle goes out of their way to ensure that it is difficult to get data out
of an Oracle database and migrate it somewhere else.
No tool supplied by Oracle will extract the data in a useful format.
If you use Toad (an expensive third party tool), that will do the trick.
There is also ora2pg or oracle_fdw to extract data from Oracle to PostgreSQL.
I'm only speaking about the actual data here, not the metadata.
ora2pg does a good job there, but you'll probably need to do some
stuff by hand or check that ora2pg's suggestions are sane.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | DFE | 2013-09-13 15:02:39 | PostgreSQL 9.3 Error when trying to run Create Extension postgis |
| Previous Message | Matt Musgrove | 2013-09-12 19:24:19 | Re: Will This Work? |