UNIX spool command not extracting complete record from the Oracle table

Linux and Unix-Like UNIX and Linux Applications
1

Hello All,

I'm trying to spool an oracle table data into a csv file on unix server but the complete record is not being extracted. The record is almost 1000 characters but only 100 characters are being extracted and rest of the data getting truncated.

I'm setting below options :

SET HEADING OFF
SET SPACE 0
SET PAGESIZE 0
SET PAGESIZE 1000
SET LINESIZE 10000
SET FEEDBACK OFF
SET TAB OFF
SET TRIMSPOOL ON

Please suggest

Thanks in advance

2

are you dumping it straight to LP?

if so it might be the printer config.

try dumping the output to a txt file then reading it.

3

What is the data type of the columns involved? If it's LONG, CLOB, NCLOB or XMLType the default width is set by LONGCHUNKSIZE of LONG, whichever is smaller.
To ignore the default width use the COLUMN command:

COLUMN you_clob_column FORMAT A1000

PS.: the SPOOL command is not a UNIX, but a SQL*Plus command.

1 Like
4

Aren't the two above somewhat contradictory?

And this is maybe better left out until you know exactly what to trim.

As this seems to be an application problem i am going to transfer this thread to the application section.

I hope this helps.

bakunin

1 Like
5

Hello All,

Thanks very much for the responses.

Issue is resolved now.

Thank you
Venkat