Skip site navigation (1) Skip section navigation (2)

Migrating db from Oracle to Postgresql

From: Colin Barnard <cgb(at)dcs(dot)qmul(dot)ac(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Migrating db from Oracle to Postgresql
Date: 2001-11-19 14:01:31
Message-ID: 3BF910BB.DEDD627D@dcs.qmul.ac.uk (view raw or flat)
Thread:
Lists: pgsql-novice
Hello there

We have a few small but critical Oracle databases currently running on a
Solaris platform. Is it possible to import the product of an Oracle
export, filename.dmp, directly into Postgres? The dmp file is binary not
sql text :-(

(Looked through faq's and archives)

All suggestions most gratefully received
Many thanks

Colin

-- 

Colin Barnard  cgb(at)dcs(dot)qmul(dot)ac(dot)uk

Department of Computer Science, Queen Mary,
University of London, Mile End Road, London E1 4NS.
Tel: +44 (0)20 7882 5234  Fax: +44 (0)20 8980 6533

And now for something completely off the wall ...

|\
|-0
|/
|    
|   /
|_/

(Its a hook for hanging a picture on)

Responses

pgsql-novice by date

Next:From: Francisco ReyesDate: 2001-11-19 16:54:30
Subject: Re: Migrating db from Oracle to Postgresql
Previous:From: Horst HerbDate: 2001-11-19 02:02:16
Subject: performance benefit with views?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group