Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Migrate postgres DB to oracle

Re: Migrate postgres DB to oracle

From: bcochofel <bruno.cochofel_at_gmail.com>
Date: 7 Apr 2007 01:47:43 -0700
Message-ID: <1175935663.030402.169630@d57g2000hsg.googlegroups.com>


On Apr 6, 4:58 pm, DA Morgan <damor..._at_psoug.org> wrote:
> bcochofel wrote:
> > I need some help to migrate a postgres 7.4 DB to a oracle DB.
> > Where can I found tools, SW or some kind of script to help me with
> > this?
>
> > Thanks,
> > Bruno
>
> Tools? Scripts?
>
> Are you talking only data or code?
>
> Is it your desire to make every table a heap table and every index
> B*Tree or do you want something that will scale and perform?
>
> What version of Oracle?
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

I believe the version will be 10g R2.
I want to migrate the postgres database to oracle. The entire tables, with triggers and all.
I believe once this is done filling the oracle DB with the data will be easy. Received on Sat Apr 07 2007 - 03:47:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US