Received: from ns1.engrs.org (ns1.engrs.org [216.54.29.10])
	by hub.org (8.10.1/8.10.1) with ESMTP id e7EKU0w73842
	for <pgsql-interfaces@postgresql.org>;
	Mon, 14 Aug 2000 16:30:00 -0400 (EDT)
Received: (from uucp@localhost) by ns1.engrs.org (8.9.3/8.9.3) id QAA16453;
	Mon, 14 Aug 2000 16:41:20 -0400
Received: from UNKNOWN(216.54.29.80), claiming to be "greatbridge.com"
	via SMTP by ns1.engrs.org, id smtpdjAmW05; Mon Aug 14 20:41:10 2000
Message-ID: <39985636.9238E517@greatbridge.com>
Date: Mon, 14 Aug 2000 16:27:34 -0400
From: Chris Ryan <chris@greatbridge.com>
Organization: GreatBridge LLC
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-6.1.1 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: John David Garza <garza@cjas.org>
CC: pgsql-interfaces@postgresql.org
Subject: Re: Migration
References: <Pine.BSF.4.10.10008141404500.31876-100000@localhost>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200008/94

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