| |
Posted: Apr 08, 2008 12:29:30 AM |
Total Post: 24
Joined: Feb, 2008
|
Hi,
Q1. can space of the table be release after truncate command in oracle 9i.
Thanks
|
|
|
 Murtuja |
| Posted: Apr 08, 2008 02:37:05 AM |  |
|
Total Post: 814
Joined: Jan, 2006
|
Use the TRUNCATE statement to remove all rows from a table or cluster. By default, Oracle Database also deallocates all space used by the removed rows except that specified by the MINEXTENTS storage parameter and sets the NEXT storage parameter to the size of the last extent removed from the segment by the truncation process.
|
|
|
|
|
| Gitesh |
| Posted: Apr 08, 2008 06:25:17 AM | |
|
Total Post: 322
Joined: May, 2005
|
Default truncate command's behavior as above but if you use truncate command with "reuse storage" doesn't release space.
|
|
|
|
|
| ramesh |
| Posted: Apr 10, 2008 07:39:26 AM | |
|
Total Post: 69
Joined: Dec, 2006
|
an addition
truncate command moves the highwater mark and is an DDL statment
the transaction cannot be rollback.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
