Can I read Shrinking Undo Tablespace in Oracle on EtoBox?

Shrinking Undo Tablespace in Oracle by Printesh Patel is a document available to read on EtoBox.

What is Shrinking Undo Tablespace in Oracle about?

To shrink the undo tablespace: 1. Create a new undo tablespace with a smaller datafile size and make it the default. 2. Check that there are no active undo segments in the original tablespace. 3. Drop the original undo tablespace to free up disk space.

Author

Printesh Patel

Language

EN