On 04/03/12 11:13 AM, leaf_yxj wrote:
> Hi John, Thanks for your reply. Just to confirm : so truncate table
> means the space will be reclaim for reuse ???
yes, all the tablespace is immediately returned to the file system when
the transaction with the TRUNCATE statement commits.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast