| Clearing TableSpace [message #71035] |
Thu, 29 August 2002 05:49  |
Achyuth B
Messages: 8
Registered: November 2000
|
Junior Member |
|
|
Hello,
I would like to know how to clear the data in Tablespace. For testing, we have inserted many large objects in BLOB which has occupied full tablespace size. We have deleted all the rows from the table, but still the tablespace has filled with full space.
Could anybody help me in getting solution for how to clear the data in tablespace.
Thanks in advance
Best Regards,
Achyuth
|
|
|
|
| Re: Clearing TableSpace [message #71036 is a reply to message #71035] |
Thu, 29 August 2002 06:47  |
null null
Messages: 2
Registered: August 2002
|
Junior Member |
|
|
try using the COMPACT command after deleting large
volumnes of data to reclaim and reuse storage space.
TRUNCATE TABLE
alleviates the need to
use COMPACT..it is automatically done.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
