08-06-2008 6:25 AM
Hi friends,
When i use
DATA: GRID TYPE REF TO CL_GUI_ALV_GRID.
i m getting the error like following
" SQL error 1654 occurred when accessing program "Z1V10007 " part "LREF". "
How to resolve this probelm ???
Thanks in advance
Ajay kumar
08-06-2008 6:51 AM
Hi Ajay,
Check the free space available in the tablespace..
2. Check when the indexes in ur database ( all indexes.. not just that one)
are rebuilt last time. Rebuilding the indexes at regular intervals is
required as it may contain deleted entries. try a rebuild ( may be later )
3. Add more space to the tablespace ( add a datafile ) or if you have
another tablespace designated for Indexes and it has sapce in it, the
rebuild ur index in the second tablespace
Also,
Be that your tablespace has reached its max ext.
Check the properties of the table space and make sure your ext value is not
set too low.
If the tablespace reaches it max it wont matter what is set at the table
level.
Or
other wise the datafile file size would have got exhausted. in that case
either add a new datafile to your tablespace or resize the existing
datafile.
Try to perform this,
Maybe you can try the following:
- Rebuild the index
- Rebuilt the index in a different tablespace
- Resize the datafile of the tablespace that stores the index
- Add a new datafile to the tablespace that stores the index
also, Alter index <index name> allocate extent;
Mohinder
08-06-2008 6:29 AM
08-06-2008 6:51 AM
Hi Ajay,
Check the free space available in the tablespace..
2. Check when the indexes in ur database ( all indexes.. not just that one)
are rebuilt last time. Rebuilding the indexes at regular intervals is
required as it may contain deleted entries. try a rebuild ( may be later )
3. Add more space to the tablespace ( add a datafile ) or if you have
another tablespace designated for Indexes and it has sapce in it, the
rebuild ur index in the second tablespace
Also,
Be that your tablespace has reached its max ext.
Check the properties of the table space and make sure your ext value is not
set too low.
If the tablespace reaches it max it wont matter what is set at the table
level.
Or
other wise the datafile file size would have got exhausted. in that case
either add a new datafile to your tablespace or resize the existing
datafile.
Try to perform this,
Maybe you can try the following:
- Rebuild the index
- Rebuilt the index in a different tablespace
- Resize the datafile of the tablespace that stores the index
- Add a new datafile to the tablespace that stores the index
also, Alter index <index name> allocate extent;
Mohinder