Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

can i use alter table table_name Coalesce

428632Feb 22 2006 — edited Feb 22 2006

I made pctincrease to 0 from 50 because of high next_extent value, now i want to release unnecessary space used by the tables so please advise can i use the
alter table <table_name> coalesce;

will this command release extraspace occupied by the table

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 22 2006

Added on Feb 22 2006

#general-database-discussions

2 comments

235 views