PostgreSQL data -> Oracle
PostgreSQL data -> Oracle
От:
leonardo.camargo@eds.com (Leonardo Camargo)
Дата:
Hi, How can i migrate the data from a PostgreSQL db to an Oracle database ? Any tip, advice, article, howto would be helpful. thnx in adv. Ka
Re: PostgreSQL data -> Oracle
От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
Leonardo Camargo wrote: > Hi, > > How can i migrate the data from a PostgreSQL db to an Oracle database ? > > Any tip, advice, article, howto would be helpful. Wow, this is getting to be an FAQ. See contrib/oracle and for tips, see the techdocs.postgresql.org site. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Re: PostgreSQL data -> Oracle
От:
"Nick Fankhauser" <nickf@ontko.com>
Дата:
Back in the days when I used Oracle, there was something called SQL*Loader that allowed you to read a flat ASCII file into an Oracle table. If I were doing this, I think I'd do a pg_dump of the data, filter the dump file to remove the "copy" commands & then use SQL*Loader or it's newer equivalent on the dump file. Of course we're all just aghast that you'd want to do such a thing... -Nick > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Leonardo Camargo > Sent: Friday, July 05, 2002 4:04 PM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] PostgreSQL data -> Oracle > > > Hi, > > How can i migrate the data from a PostgreSQL db to an Oracle database ? > > Any tip, advice, article, howto would be helpful. > > thnx in adv. > > Ka > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > >