• About
  • Archives
  • 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: truncate

October 5, 2018 Uncategorized

Partial Indexes–Take Care With Truncate

Partial indexes are a very cool feature that came along with Oracle 12c. The capability at partition level to control

Continue reading

October 21, 2016 Uncategorized

Truncating a timestamp to the second

We had an interesting AskTom question recently, about why certain TRUNC commands would generate an error when applied to a

Continue reading

December 18, 2015 Uncategorized

How do I stop the use of TRUNCATE

Truncate is one of those commands that cannot be undone trivially…In fact, you might well be looking at a database

Continue reading

Over 500 posts …

Connect with me

  • 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

Enter your email address to follow this blog and receive notifications of new posts by email.

Top Posts & Pages

  • NULL's vs NOT NULL's and Performance
  • All the OpenWorld 2019 downloads!
  • Long running scheduler jobs
  • Shirts of OpenWorld
  • Cross-platform database migration
  • Updating indexes with partition maintenance
  • Attribute clustering….super cool
  • Modifying tables without losing materialized views
  • The death of UTL_FILE
  • Connection shortcuts with a wallet
Blog at WordPress.com.