How can you shrink an Oracle tablespace?

Answered on : 2024-01-24

Sources

How to Shrink the Tablespace of a Table in an Oracle ...

medium.com

1

How to Shrink an Oracle Tablespace

blog.mertech.com

2

Oracle shrinking / reclaiming free tablespace space

dba.stackexchange.com

3

view 7 more

To shrink an Oracle tablespace, you can follow these steps:

1. **Remove Unwanted Data:**

- Consider using the `TRUNCATE TABLE` command to delete unwanted data before shrinking the tablespace[1].

2. **Purge Tablespace:**

- Use the `PURGE TABLESPACE` command to release space within the tablespace[2].

3. **Alter Tablespace Coalesce:**

- Execute the `ALTER TABLESPACE ... COALESCE` command to reclaim free space in the tablespace[2][5].

4. **Alter Table Shrink Space:**

- Utilize the `ALTER TABLE ... SHRINK SPACE` command to compact rows, move down the High Water Mark (HWM), and release unused space[3].

Always consider the specific commands based on your Oracle version and requirements.

Related

Comment puis-je obtenir ma carte T en tant que mandataire immobilier depuis 7 ans ?

为什么小仙女会成为版本T0？

How can I increase post content length in WordPress?

What should I do if the POST Content-Length of bytes exceeds the limit in PHP?

How can one change the MoveIt goal state through code?

Is 64 degrees too cold for shorts?

How does Think-Cell read columns and rows from Excel?