Reclaim space from tablespaces ONLINE with ONE command

No more late nights with high risk unload/reload strategies. In Oracle Database 23ai you can now shrink a tablespace and its datafiles down to their optimal size with a simple one line command.

Addenda: In the latest 23ai release, "tablespace_shrink" is renamed to "shrink_tablespace"

Also, this is for BIGFILE tablespaces. See my post for details https://connor-mcdonald.com/2023/11/0...

Follow me!
blog: https://connor-mcdonald.com
twitter:   / connor_mc_d  

The Podcast!
https://podcasts.apple.com/au/podcast...
https://open.spotify.com/show/5dqVVft...

Subscribe for new tech videos every week

Other social media channels here: https://linktr.ee/connor

Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla

#sql #database