truncate [message #278661] |
Mon, 05 November 2007 05:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Hi,
I have a table which has reached an extent of 194 (times) over 249 (times).
This table contains many records and I want to truncate the table.
If I truncate it, will the extent reached of 194 times drop to 0 time(s).
Thank you,
Dirish
|
|
|
|
Re: truncate [message #278674 is a reply to message #278671] |
Mon, 05 November 2007 06:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
yea sure, the initial extent should exist, but first records should fill the initial extent to move on to the next extent.
|
|
|
|
|
|
Re: truncate [message #279940 is a reply to message #279149] |
Mon, 12 November 2007 00:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Hi All,
I did the test and in fact the extent reached fell to 0.
I have another issue.
I have a table in oracle 7 and want to increase the next extent. Is this possible?
Thx
|
|
|
|
Re: truncate [message #279948 is a reply to message #279940] |
Mon, 12 November 2007 00:58 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | I did the test and in fact the extent reached fell to 0.
|
This is wrong, post your evidence.
Regards
Michel
|
|
|