Re: SQL Loader export facility

The Spool command in SQL*Plus is probably your best solution in Linux. Oracle-specific objects like BLOBS, LOBS, Longs and Raw will be very difficult but all of the other datatypes will be fairly easy. Assuming you can place one logical record on every physical line, please see the example below. Obviously you'll have to post-process the spooled output into some type of insert or load format that PostGres can handle.

ie

set pagesize 0;
set feedback off;
set verify off;
spool <outfile_name>;
spool <col1>||,||<col2>||....
from <table>
/
spool off;

Cliff Received on Fri Dec 28 2001 - 02:18:41 CET