Re: Extracting ASCII files from database

From: <the_very_at_my-dejanews.com>
Date: Mon, 13 Jul 1998 11:32:02 GMT
Message-ID: <6ocr7i$qtf$1@nnrp1.dejanews.com>

Hi, Sigrid,

you can use spool etc. This will give you an adequate ascii_file without much hassle. It will however not give you much control or error messaging. I personally use UTL_FILE, it's description is available in Oracle documentation. Off course you would have to write a pl_sql program. If needed I can mail you an example.

In article <35A939BC.7FA48F00_at_sachsenlb.de>, Sigrid Staudte <sstaudte_at_sachsenlb.de> wrote:
> Hi,
>
> I have to extract an ASCII file with fixed length of fields from a
> database table. This file should be transfered to another server and
> loaded by the sql*loader. Now I´m searching for the best way to extract
> the ASCII file.
> Can I use the spool command and sql*plus or is it necessary to write a
> pl/sql-programm ?
> Who can give an advice?
> Who knows a tool what can help to solve the problem ?
>
> Regards,
>
> Sigrid
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Jul 13 1998 - 06:32:02 CDT