Thread: Where Can I Find...
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. 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.
TIA,
Gene
It's impossible for everything to be true at the same time.
TIA,
Gene
It's impossible for everything to be true at the same time.
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
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
On 1/25/2013 8:21 AM, Gene Poole wrote:
lso 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.
if you don't want to use RPM, why did you choose an RPM based distribution?
is '6 single sided DVDs' a cute way of saying around 24 GB of data?
there's absolutely NO reason to use a bunch of tablespaces for a database that small. we use tablespaces for multi-terabyte databases. Instead, on modern hardware, just put a bunch of small/fast disks in a raid10 and use that for the whole thing.
An Oracle 'instance" is roughly equivalent to a postgres 'database', the instance can have many schemas within it.
For copying the data across, I'd look into ETL packages, such as http://www.jaspersoft.com/JasperSoft_JasperETL.html
these can connect to different database engines, and 'extract, transform, and load', with a lot of flexibilty.
-- john r pierce 37N 122W somewhere on the middle of the left coast