Re: Exporting/spooling data to a text file

Calvin,

Try "Set pagesize 0" to allow for unlimited pagesize and do a "set linesize <max>" to your maximum line length with all columns. But I think there's an upper limit on the linesize you can set. Your varchar2(2000) problem has brought back fond memories for me. I had the same problem with a long text column a few years ago.

The question is: do absolutely need a TEXT file ? Even if you can get 1 record/line can you then process them with SQL*Load or some other tool ?

I have used the 1 record -> multi-line approach but I had to post-process the file and place a continueif character so that SQL*Load would have some kind of multi-line delimiter. However, I was migrating data from one Oracle table into another with a different structure so I was stuck with SQL*Load.

Instead of building a ladder I broke a hole in the ceiling. Can you provide more info ?

Cliff

>I'm having trouble exporting data to a text file. I've tried spooling it
>from SQL*Plus, but we
>have one table with a Varchar2(2000) field and it keeps wrapping it. SQL*Plus
>also keeps
>inserting page breaks, although I'm pretty sure I can get rid of those.
>(I think I remember
>seeing a command to set the page length and I'm sure that if I just keep
>looking then I'll find
>it again. I assume that it will allow an infinite page length but if not
>then that'll be
>another problem.)
>
>I'd like to end up with either fixed length or delimited fields, one record
>per line.
>
>I suppose I could write a 'report' program, but that seems like building
>a ladder because you
>can't get the door to the stairs open. Any ideas?
>
Received on Wed Dec 29 1999 - 19:45:40 CST