Skip site navigation (1) Skip section navigation (2)

Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64

From: Gene Poole <gene(dot)poole(at)macys(dot)com>
To: pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64
Date: 2011-12-07 14:13:10
Message-ID: OF1A68A015.B20F9DC9-ON8525795F.004C55AB-8525795F.004E18D9@MACYS.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-novice
This has to do with my personal home environment.

I'm running Oracle 11gR2 DBMS with 4 instances using a single home 
directory.  For each of the instances I'm using LVM file systems with 10 
logical volumes defined (/dbmsu00 used for the install and /dbmsu01 - u09 
for the required files created using the DBCA utility). A single LISTENER 
created using the NETCA utility.

I chose Oracle because back in the dark ages I was a Oracle DBA when 
Oracle 7.3 was current. I've been told that it's OK to download and use 
the Oracle DBMS in a noncommercial environment for a limited time - well 
it's reached the end of that time.  I can't use the free Oracle XE because 
the database size limitations (4 GB).

Based upon what I've read and seen, the best choice for me is PostgreSQL 
Community Edition. What I need is advice, documentation, and information 
on how to take the above and move it from Oracle to PostgreSQL along with 
updating my JBoss 6.0 environment so it has access to the PostgreSQL 
databases/instances?  Can someone supply me with some direction?
 
Thanks,
Gene Poole

+ It's impossible for everything to be true. +

Responses

pgsql-novice by date

Next:From: Tomas VondraDate: 2011-12-07 14:36:16
Subject: Re: [GENERAL] Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64
Previous:From: Ioannis AnagnostopoulosDate: 2011-12-07 12:14:21
Subject: Re: Linux server connection process consumes all memory

pgsql-admin by date

Next:From: Tomas VondraDate: 2011-12-07 14:36:16
Subject: Re: [GENERAL] Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64
Previous:From: Jan-Peter SeifertDate: 2011-12-07 12:46:35
Subject: Number of connections still limited on Windows 64-bit?

pgsql-general by date

Next:From: Tomas VondraDate: 2011-12-07 14:36:16
Subject: Re: [GENERAL] Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64
Previous:From: akp geekDate: 2011-12-07 14:03:28
Subject: postgres 9.0.4 Streaming relate question ..

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group