Re: [GENERAL] Trouble migrating from PostgreSQL --> Oracle

2006-11-14 Thread Jim C. Nasby
On Tue, Nov 14, 2006 at 06:08:44AM -0800, [EMAIL PROTECTED] wrote: > Good morning, > > I've recently just inherited a PostgreSQL database that is a back end > for some logistics software we use here. We have our own Oracle > servers in our group on faster machines with automated backup so we > wo

Re: [GENERAL] Trouble migrating from PostgreSQL --> Oracle

2006-11-14 Thread Dave Page
> --- Original Message --- > From: Jeff Davis <[EMAIL PROTECTED]> > To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > Sent: 14/11/06, 19:05:33 > Subject: Re: [GENERAL] Trouble migrating from PostgreSQL --> Oracle > > Use pg_dump if you sti

Re: [GENERAL] Trouble migrating from PostgreSQL --> Oracle

2006-11-14 Thread Jeff Davis
On Tue, 2006-11-14 at 06:08 -0800, [EMAIL PROTECTED] wrote: > The software came with scripts to create the owners, tables and > permissions in Oracle but when using "pgAdmin" (Windows client being > used to administer the PostgreSQL database at the moment) export > feature which dumps the entire d

[GENERAL] Trouble migrating from PostgreSQL --> Oracle

2006-11-14 Thread [EMAIL PROTECTED]
Good morning, I've recently just inherited a PostgreSQL database that is a back end for some logistics software we use here. We have our own Oracle servers in our group on faster machines with automated backup so we would like to move all the data over to Oracle. The software came with scripts t