• About
  • All Posts
  • Playlists
  • Golden Oldies
Skip to content

Learning is not a spectator sport

  • 30 second guide to India
  • About
  • Archives
  • Golden Oldies
    • First match
    • Smart DBA
  • Playlists

Tag: reorgs

February 19, 2021 Uncategorized

Free space requirements for ALTER TABLE

One of the very cool features from 12.2 onwards is that the vast majority of segment operations that require rewrite

Continue reading

May 31, 2019 Uncategorized

Advice on fragmentation and shrinkage

If you have performed some sort of data cleanup or similar on a table, then the deleted space will be

Continue reading

Over 500 posts …

Let’s connect

  • View connor_mc_d’s profile on Twitter
  • View connor_mc_d’s profile on Instagram
  • View connor-mcdonald-australia’s profile on LinkedIn
  • View UCVN7PnJnuKQ65QLmWjFvhiw’s profile on YouTube

Hi I'm Connor McDonald. I love playing with and exploring the Oracle database. But most of all I like seeing people succeed with the technology.
 
Subscribe for new posts by email.

Top Posts & Pages

  • How to do a GRANT on an entire schema
  • Extended VARCHAR2 and the hidden LOB
  • Blockchain tables are here in 19c!
  • No more stale statistics in 19c
  • My APEX was fine and then it wasn't
  • APEX 20.2 comes to town (well, to my PC)
  • Complex materialized views and fast refresh
  • DBMS_JOB - watching for failures
  • Why you keep getting "ORA-01653: unable to extend table"
  • Pluggable database and restricted sessions
Blog at WordPress.com.