| seema |
Posted: Sep 23, 2008 05:50:23 AM |
Total Post: 70
Joined: Jan, 2008
|
| Please tell me when we truncate a table will it release the space in memory??? |
|
|
 scorpio |
| Posted: Sep 23, 2008 01:06:47 PM |  |
|
Total Post: 20
Joined: Sep, 2008
|
when truncate command is issued, all the rows from the
table are deleted and the memory space occupied by the
table in the tablespace is also released
|
|
|
|
|
| GOPU |
| Posted: Sep 23, 2008 02:30:36 PM | |
|
Total Post: 340
Joined: Apr, 2008
|
i doubt that it will release the space or not ??
|
|
|
|
|
| scorpio |
| Posted: Sep 24, 2008 06:40:52 AM | |
|
Total Post: 20
Joined: Sep, 2008
|
It will release tablespace .What prompt to u say that it will not release the space if u highlight a bit then i can give a better explanation .
Do one thing , u load records say 20K and more and then try to truncate the records manually and parallell observe the OEM (diagrammatical representation ) and u will clearly see that its releasing space .
|
|
|
|
|
| balaji |
| Posted: Nov 08, 2008 08:35:17 PM | |
|
Total Post: 162
Joined: May, 2008
|
yes u r right scorpio,it will certainly release the space in tables and also the High water mark will come to its starting position in table.
Regards,
Balaji
|
|
|
|
|
| vineet |
| Posted: Nov 13, 2008 03:25:14 AM | |
|
Total Post: 3
Joined: Nov, 2008
|
Records say 50K and more and then try to truncate the records manually and parallell observe the OEM and you will clearly see that its releasing space .
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
