I got good results in a test case, just using a standard PostgreSQL dump
file created with INSERT statements (pg_dump -d). All it needed was a
little editing to change some of the data types in the table definition,
e.g. from text and varchar to varchar2 (if your Oracle table is set up, you
won't even have to do that: just do a pg_dump -a -d).
The only other thing I needed to do was edit dates into the form that Oracle
likes: DD-MMM-YY. I believe that this default can be changed though, I just
couldn't find a reference quickly enough to suit.
This approach was necessary because I was testing a development version of
Oracle (the freely downloadable one), which doesn't include the
import/export tools, so I had to use the sqlplus interface. If you have the
import tools, you can just import from a delimited text file, as can be
created using COPY: read the documentation for your Oracle installation.
> -----Original Message-----
> From: martin.chantler@convergys.com [SMTP:martin.chantler@convergys.com]
> Sent: Thursday, April 26, 2001 10:13 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Data Export from PostGreSQL
>
>
> For the purposes of a demo I have to export data from a PostGresSQL system
> to Oracle
> (I know, I know not my choice)
>
> Is there an easy way of dumping all the data in a format Oracle can
> understand?
>
> Any help appreciated,
>
> Thanks,
> Martin C.
>
>
> --
>
> NOTICE: The information contained in this electronic mail transmission is
> intended by Convergys Corporation for the use of the named individual or
> entity to which it is directed and may contain information that is
> privileged or otherwise confidential. If you have received this
> electronic
> mail transmission in error, please delete it from your system without
> copying or forwarding it, and notify the sender of the error by reply
> email
> or by telephone (collect), so that the sender's address records can be
> corrected.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster