From: Walter Hurry <walterhurry@lavabit.com>
To: pgsql-admin@postgresql.org
Subject: Re: Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64
Date: Wed, 7 Dec 2011 15:43:22 +0000 (UTC)
Message-ID: <jbo1iq$9sq$1@dough.gmane.org> (raw)
References: <OF1A68A015.B20F9DC9-ON8525795F.004C55AB-8525795F.004E18D9@MACYS.com>
On Wed, 07 Dec 2011 09:13:10 -0500, Gene Poole wrote:
> 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?
I use PostgreSQL at home from *choice* (I am an Oracle DBA at work). But
I don't think there is any time limit on personal non-commercial use of
Oracle EE (you may want to check the OTN Licence Agreement on their
download page).
PostgreSQL is FOSS, so there are no "Editions", by the way.
Lastly, a couple of polite requests: Please do not post HTML, and please
consider carefully before crossposting to multiple groups.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: walterhurry@lavabit.com
Subject: Re: Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64
In-Reply-To: <jbo1iq$9sq$1@dough.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox