UNIX for Advanced & Expert Users

what does it mean

set linesize 200;
set linesize 2000;

i am spooling the data into a file .When i give 200 the size of file is 72MB.
When i give 2000 its 720 MB.How do i know if i am getting all the data.......?

FROM GOOGLE

In SQLPLUS use the "set linesize n" command to the maximum line-width of your record.

SET LINESIZE {80|n}
Sets the total number of characters that SQL*Plus displays on one line before beginning a new line. It also controls the position of centered andright-aligned text in TTITLE, BTITLE, REPHEADER and REPFOOTER. You can define LINESIZE as a value from 1 to a maximum that is system dependent.

Example:
EMP:
LASTNAME Varchar2(30)
Firstname varchar2(30)
Phone varchar2(11)Comment varchar2(200)

For a table like that, the max linesize of the record would be 271 + 3 space characters
so I would probably set the linesize to 275.

Note: For checking whether you got all the data,you need to query.Use count for instance eg: select count(*) from tablename.

if you use

Code:

set trimout on

it removes trailing blanks. Otherwise SQLPLUS will pad your output with trailing blanks up to the value of linesize.

And thumbsup is right - just count the lines in file - wc -l <filename>