If you have access to an Oracle box, you can try reloading using SQL Loader,
then any number of tools can be used to move the data from one environment
to another. I once moved Oracle 8i database to Postgres 7.0.2 via the
MS-SQL 7 Enterprise manager. All you're usually left with is making a script
to enable any constraints. Nothing imports better than the system that
generated the dump... You can download (super slow) Oracle from their site.
The Linux version is a pain if you don't RTFM , but if you're short on time
then try the brain-dead installer for the NT version.
If you don't want to get into a data massage nightmare ( they aren't that
bad after the first few if it boils down to that !) , try to get the data
back into it's native format and export it to something more meaningful to
the system you're trying to import to.
P
----- Original Message -----
From: "Leslie Johnson - Contractor" <ljohnson@arl.army.mil>
To: <pgsql-novice@postgresql.org>
Sent: Friday, September 08, 2000 3:54 PM
Subject: [NOVICE] A very novice question about ascii files
> Hi all,
> This is probably a very stupid question but I'm working on a really tight
> deadline and I'm very confused. I've got several incredibly hefty ascii
> files that were at one point Oracle databases. Now they're just plain
> ascii dump files and today I got asked to put them in PGSQL but I have no
> idea how (I've never even worked with databases before except for the
> offline variety.) Can anybody please point me towards some documentation
> that would be helpful or give me some advice?
> Thanks so much,
> Leslie
