09-12-2008 10:15 AM
Hi All,
I have a select statment which fetches data from a Z table.The data volume is more that 3 lakh records.Hence the system is giving dump 'No storage space available for extending table "IT_57".'
09-12-2008 10:19 AM
Hi Rakesh,
This is just coz you have huge amount of data to be fetched. You can avoid this by using a stringent filtering criteria i.e. WHERE clause in your select query, to get only the required records from the data base.
Regards,
Kunjal
09-12-2008 10:20 AM
09-12-2008 10:21 AM
09-12-2008 10:22 AM
You will not be able to do this. This will give you dump u run this report every time...
Regards,
K
09-12-2008 10:27 AM
Hi..
If your program goes to run in batch job please follow this.
Try to use primary fields in select query.
If you use it then change select statement into select endselect format.
Here performance is bad but memory consumption will low.
Here you fetch one record and process this record in a select endselect loop.
That's why memory consumption will low.
09-12-2008 10:31 AM
Hi Rakesh,
two ways.
1. Ask ur BASIS team to increase the memory level.
2. Check the PACKAGE SIZE option of select statement
Here u won't select all the data once but in packets of specified size. So get the packets of data and process.
Just press F1 on package size. That explanation will be enough to proceed further.
Thanks,
Vinod.
09-12-2008 11:26 AM
09-12-2008 4:47 PM