| Deallocating unused table space [message #61543] |
Tue, 04 May 2004 21:16  |
SJC
Messages: 11
Registered: December 2003
|
Junior Member |
|
|
Hi,
Please reply asap. After deletion of large amounts of record from a table(some records still remain so cannot use truncate), how do I deallocate unused table space in Oracle 7.1.3. (alter table ... deallocate unused gives ORA-01735: invalid ALTER TABLE option)
Thanks & Regards
S.J. Chanda
|
|
|
|
| Re: Deallocating unused table space [message #61556 is a reply to message #61543] |
Wed, 05 May 2004 02:39  |
Sujit Sarkar
Messages: 40
Registered: September 2003
|
Member |
|
|
alter table...deallocate unused
removes space above the high water mark. This command wouldn't serve your purpose.
To reclaim the space of any table either you can move the table into a different tablespace by the following command.
alter table ... move tablespace
;
or
export the table,constraints,grants,rows,indexes and drop the table and import it.
this way you can reclaim your unused space.
thanx & rgrds
sujit
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
