Re: Utility to dump an Oracle table
From: Follow the sun <92908250_at_cpccspc.cityu.edu.hk>
Date: 8 Feb 1995 17:29:42 GMT
Message-ID: <3hav26$aq9_at_cpccux0.cphk.hk>
Date: 8 Feb 1995 17:29:42 GMT
Message-ID: <3hav26$aq9_at_cpccux0.cphk.hk>
In article <D3nIxw.C8D_at_da_vinci.ecte.uswc.uswest.com> at Tue, 7 Feb 1995 22:39:32 GMT you wrote:
> DB2 has a utility - I think it's called DSNUTIL. It will download a DB2
> table in fixed column flat file format. Does anyone know if there is an
> Oracle utility like this? We do not want to use export because direct
> load is faster than import and we are dealing with very large volumes.
No, but you can use the spool function to do the simliar things. First wirte a file like that :
---Cut Here---
set echo off
set pause off
set header off
col col1 format ...
Received on Wed Feb 08 1995 - 18:29:42 CET