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
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>