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!

Free space after deleting table

Mustafa MohammedSep 10 2014 — edited Sep 10 2014

Hi All,

When I remove rows from table, I still have in dba_tables in column num_rows, the number of rows before deletion, that mean the space still occupied

I tried to user the shrink command but still the num_rows is there,

Could anyone provide how can I free space after the deletion so the num_rows should be 0

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 8 2014

Added on Sep 10 2014

#general-database-discussions

6 comments

1,863 views