: [ADMIN] Oracle and Postgresql Play Nice Together on Same
Computer?
Troyston Campano [EMAIL PROTECTED] wrote on 20.01.2005,
06:03:28:
I am an Oracle DBA and I want do a Postgresql 'proof of concept' at the
large corporation where I work to test the benefits of using Postgresql in
our
It depends how you have your Oracle instance configured. If you have
it set up so that the total SGA and UGA ammount consume around 80%-90%
of total available memory, then this is obviously only going to leave
postgress with 20% or less of the total available memory. Postgres is
also designed to
On Fri, Nov 14, 2003 at 12:07:40PM +0100, Jouneau Luc wrote:
During our impact tests, we encountered a situation where no more semaphore
was available for Oracle server (while we where bulk loading on postgreSQL
using copy statement. There was only one PG connection while there were many
on
Tom Lane wrote:
Jouneau Luc [EMAIL PROTECTED] writes:
We plan to install on a same Solaris server an Oracle8i and a PostgreSQL
7.3.4 database.
During our impact tests, we encountered a situation where no more semaphore
was available for Oracle server (while we where bulk loading on
Marco Roda [EMAIL PROTECTED] wrote ..
Hi,
I need to port data from an Oracle 8.0 base to PostgreSQL 7.2. I have
scripts to create the base on Oracle and PostgreSQL (it is about 40
tables), but I need to port a great amount of data to PostgreSQL.
Can anybody help me?
I never see any
On Wed, 6 Aug 2003, Marco Roda wrote:
Hi,
I need to port data from an Oracle 8.0 base to PostgreSQL 7.2.
I have scripts to create the base on Oracle and PostgreSQL (it is about 40
tables), but I need to port a great amount of data to PostgreSQL.
Can anybody help me?
There's a script in
hi,
At 10:25 07.08.2003 +0200, Bruno BAGUETTE wrote:
Marco Roda [EMAIL PROTECTED] wrote ..
Hi,
I need to port data from an Oracle 8.0 base to PostgreSQL 7.2. I have
scripts to create the base on Oracle and PostgreSQL (it is about 40
tables), but I need to port a great amount of data to
What are the legal implications of copying Oracle's own PL/SQL
procedures code and porting them to PgSQL as you suggested?
Bruno BAGUETTE wrote:
Marco Roda [EMAIL PROTECTED] wrote ..
Hi,
I need to port data from an Oracle 8.0 base to PostgreSQL 7.2. I have
scripts to create the base on
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July 03, 2002 2:25 PM
Subject: Re: [ADMIN] Oracle data - PostgreSQL
If I were tasked to do it, I'd probably use PERL and DBI/DBD. Once you
get all the Oracle tables converted and built in Postgres, you could
write a PERL program to open
We're working
to create a package of Oracle procedures and documenation for this
process and hope to release it in the future.
Release early and often.
Cheers,
--
Tim Ellis
DBA, Gamet
---(end of broadcast)---
TIP 2: you can get off all lists
Leonardo Camargo wrote:
Hi
How do i migrate data from an Oracle db to a PostgreSQL db ?
Is there an article, paper, site, howto, aboutm it?
Any point would be helpful
Sure, see /contrib/oracle/ora2pg and techdocs.postgresql.org.
--
Bruce Momjian|
If I were tasked to do it, I'd probably use PERL and DBI/DBD. Once you
get all the Oracle tables converted and built in Postgres, you could
write a PERL program to open a database descriptor to your oracle
database and postgres database at the same time. Then, copy all the
records in each
12 matches
Mail list logo