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-16 14:26:57
Message-ID: 3BF52231.28154A58@dcs.qmul.ac.uk (view raw or flat)
Thread:
Lists: pgsql-novice
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 :-(

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)

pgsql-novice by date

Next:From: Jason EarlDate: 2001-11-16 16:44:13
Subject: Re: Perl and pgsql...
Previous:From: Tom LaneDate: 2001-11-16 06:16:27
Subject: Re: switching from mysql

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