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

Re: Migration

From: Chris Ryan <chris(at)greatbridge(dot)com>
To: John David Garza <garza(at)cjas(dot)org>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Migration
Date: 2000-08-14 20:27:34
Message-ID: 39985636.9238E517@greatbridge.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
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(at)greatbridge(dot)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(at)keyframe(dot)cjas(dot)org

In response to

pgsql-interfaces by date

Next:From: chriswoodDate: 2000-08-15 12:43:27
Subject: What does this pgAdmin error mean?
Previous:From: Mike MascariDate: 2000-08-14 19:05:55
Subject: Re: Migration

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