From: Chris Ryan <chris@greatbridge.com>
To: John David Garza <garza@cjas.org>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Migration
Date: Mon, 14 Aug 2000 16:27:34 -0400
Message-ID: <39985636.9238E517@greatbridge.com> (raw)
References: <Pine.BSF.4.10.10008141404500.31876-100000@localhost>
It's been a while since i did much with Oracle but last time I did do
something there was a sql loader (don't remember exact name) but you
create the table seperately then create loader files that specify the
format and table and methods to use to load in a flat datafile. This is
probably more work than you were looking for though; having to break up
the dump file into several files.
Chris Ryan
chris@greatbridge.com
John David Garza wrote:
>
> Hello all,
>
> I've got another question for anybdy that's done Postgres -> Oracle
> migrations. Is there a way for oracle's sqlpls to do a read from <stdin>
> like psql does with the pg_dump files? Or am i going to have to take this
> pg_dump file and replace all the <stdin> lines with INSERT lines?
>
> Or, is there a way for pg_dump to just dump sql only?
>
> John David Garza
> garza@keyframe.cjas.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: chris@greatbridge.com, garza@cjas.org
Subject: Re: Migration
In-Reply-To: <39985636.9238E517@greatbridge.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox