Whether Oracle Delete then Truncate will release the Delete data takes up space?-CodePudding

Oracle database, the physical disk capacity is insufficient, the table data backup, Delete off some data first, and then the Truncate table, Delete, please Delete the part of the data of the physical space occupied released? If not, how to release the space?

CodePudding user response:

please Delete Delete that part of the data of the physical space occupied released?
The release of the

The original poster can check user_segments verify,

CodePudding user response:

reference 1st floor selling fruit net reply:

please Delete Delete that part of the data of the physical space occupied released?
The release of the

The original poster can check user_segments verify,

ok, thank you

CodePudding user response:

Not delete or truncate can release the space, the data file size no change, just space release to table space, but not release to the operating system,
Unless you are contracted or rebuild the table space, table space itself have changed data file size,

CodePudding user response:

reference Rotel reply: 3/f

can release of the space is not delete or truncate, itself a data file size no change, just space release to table space, but not release to the operating system,
Unless you contracted or rebuild the table space, table space itself have changed data file size,

yes, yes, yes, at that time is indeed in order to be able to recycle the current table space, so delete the related data in the table, only have deleted with the delete this doubt, also want to consult, multiple data files, have a plenty of automatic growth or not, using again will there be affected?

CodePudding user response:

reference 4 floor of a white robe dipped up response:

Quote: refer to the third floor Rotel response:
can release of the space is not delete or truncate, itself a data file size no change, just space release to table space, but not release to the operating system,
Unless you contracted or rebuild the table space, table space itself have changed data file size,

yes, yes, yes, at that time is indeed in order to be able to recycle the current table space, so delete the related data in the table, only have deleted with the delete this doubt, also want to consult, multiple data files, have a plenty of automatic growth or not, using again will there be affected?

1. If it is to empty all data, use truncate, delete won't be able to reduce the high water level, there will be a performance issue,
2. Release the space to oracle automatically reuse, need not care about,

CodePudding user response:

reference 5 floor freedom and responsibility of reply:

Quote: refer to 4th floor of a white robe dipped up response:

Quote: refer to the third floor Rotel response:
not delete or truncate can release space, data file size itself does not change, only the space release to table space, but not release to the operating system,
Unless you contracted or rebuild the table space, table space itself have changed data file size,

yes, yes, yes, at that time is indeed in order to be able to recycle the current table space, so delete the related data in the table, only have deleted with the delete this doubt, also want to consult, multiple data files, have a plenty of automatic growth or not, using again will there be affected?

1. If it is to empty all data, use truncate, delete won't be able to reduce the high water level, there will be a performance issue,
2. Release the space to oracle automatically reuse, need not care about,

oh oh, ok, thank you