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!

re-use space from record deleted

user495715Jan 10 2017 — edited Jan 10 2017

Hi all,

I've a general question on how Oracle manage segmente free after a deletion.

If I delete all records from an historical partition from a table without truncating or dropping the partition, the table can re-use that free space for new records that will belong to a new partition?

My database version is: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0

Thanks in advance,

Samuel

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 7 2017

Added on Jan 10 2017

#delete, #general-database-discussions

4 comments

1,021 views