Re: Where Can I Find...

On Jan 25, 2013, at 8:21 AM, Gene Poole <gene(dot)poole(at)macys(dot)com> wrote:

> I'm looking for a <detailed> tutorial on how to move a Oracle 11gR2 database that consists on 4 instances with table spaces spread across multiple file systems to PostgreSQL. I need to do this because most of the open source CMS packages do not play with Oracle. The amount of data stored in the four instances (or schemas) would fit on 6 single layer DVDs, so it's not a large amount of data.

I doubt you'll find one. http://wiki.postgresql.org/wiki/Oracle probably has something useful, and http://ora2pg.darold.net

Given it's not a desperately huge database your best bet might just be to build a scratch system or VM (if a dump is less than 30gigs it's the sort of size you can handle on your laptop) and just do it. Convert the schema manually and import the exported data, or use ora2pg to automate some of it, then ask questions when you hit specific problems.

If you're using stored procedures things get more interesting, and they'll need to be rewritten. Once you've got the data ported you'll likely need to rewrite some of the queries your apps use, as oracle has some differences.

If you have budget, you might want to take a look at http://www.enterprisedb.com.

> Also I don't want to use RPM because I like to control where software is installed. Another piece on information is that I am running on CentOS 5.8.

Avoiding RPMs is probably not a good operational choice, BTW.

Cheers,
Steve