| SQL*PLUS generated abnormal file size. [message #279648] |
Fri, 09 November 2007 09:03  |
ashwin_tampa
Messages: 40
Registered: October 2005
|
Member |
|
|
Hello Guys,
I am facing a problem with SQL*PLUS generated file output.
Here is the situation:
Correct file size should be: 64,905 KB (i.e. 624,221 rows from the query)
But I am getting abnormal file size: 3,049,286 KB !!
And when I try to open my Texpad is says :
TexPad message: Disk full while accessing C:\sample_data\AHCA_RX_11092007_Q3.txt
What could be wrong?
Any help will be greatly appreciated!
Here is file configuration:
SET ECHO OFF
SET SERVEROUTPUT ON SIZE 1000000
SET LINE 5000
SET VERIFY OFF
SET PAGESIZE 0
col filename1 new_value filename1
select DISTINCT 'AHCA_RX_'||TO_CHAR(SYSDATE,'MMDDYYYY')||'_Q'||(TO_CHAR (SYSDATE, 'Q') - 1)||'.txt' filename1 from dual;
spool c:\pharm_data\&filename1
.......And my code goes here.................
SPOOL OFF
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
