On Jan 25, 2013, at 8:21 AM, Gene Poole <gene.poole@macys.com> wrote:
> I'm looking for a <detailed> tutorial on how to move a Oracle 11gR2 database that consists on 4 instances with table
spacesspread across multiple file systems to PostgreSQL. I need to do this because most of the open source CMS
packagesdo not play with Oracle. The amount of data stored in the four instances (or schemas) would fit on 6 single
layerDVDs, 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
lessthan 30gigs it's the sort of size you can handle on your laptop) and just do it. Convert the schema manually and
importthe 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
dataported 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
thatI am running on CentOS 5.8.
Avoiding RPMs is probably not a good operational choice, BTW.
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general