• About
  • All Posts
  • The Podcast!
  • 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
  • The Podcast!

Tag: dba

a black and white picture of a womans face repeated several times
June 8, 2022 Uncategorized

Comparing two database objects for differences

Ask an Oracle practitioner what DBMS_METADATA is used for, and they’ll (correctly) tell you it used to retrieve the DDL

Continue reading

a collection of crushed plastic bottles ready for recycling
May 30, 2022 Uncategorized

Recycling saves the planet but maybe not your database

The recyclebin is a very cool feature in the Oracle Database, and a great “Get of our jail free” card

Continue reading

a large bank safe locked shut
May 25, 2022 Uncategorized

Is my table marked for archive?

In 12c, we introduced a feature call Row Archival, which is a means of integrating typical archival models that we

Continue reading

a picture of the original hard copy oracle manuals from version 4 to version 8
May 13, 2022 Uncategorized

Version 7 was so much better…

Full disclosure: This is a rant post. If you’re not into ranting and pontificating, perhaps best to move along now

Continue reading

a set of square shelves each holding various jars of spices being a metaphor for a database partitioned table
April 22, 2022 Uncategorized

Implementing dynamic partitions AND subpartitions

One of the cool things to come out of the partitioning option many moons ago was the feature known as

Continue reading

a non-descript blob of red paint
April 6, 2022 Uncategorized

DBMS_METADATA for INDEXES

Just a quick tip on using DBMS_METADATA that caught me out the other day. If you have a table and

Continue reading

a female police officer standing guard
March 30, 2022 Uncategorized

Enforcing DEFAULT values

Handling default values on columns has been an age old problem that we solved in 12c with extensions to the

Continue reading

a cassette tape with the tape unravelling out of it
March 28, 2022 Uncategorized

Block recovery a lot easier than I thought

I tweeted this snippet the other day because to be honest I was just overjoyed about being able to get

Continue reading

two hands shuffling a deck of cards in close up
March 22, 2022 Uncategorized

When re-ordering columns is warranted

Nearly 10 years ago(!!!) I blogged about how you can toggle columns to invisible and back again as a means

Continue reading

a truck overfilled with cut logs driving on the highway
March 10, 2022 Uncategorized

Don’t run tight on PGA

The database on my laptop seemed slow this morning. Normally I would put this down to the fact that I’ve

Continue reading

Posts navigation

1 2 3 … 21 Next Posts»

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
  • Why you keep getting "ORA-01653: unable to extend table"
  • Extending in-lists past the 1000 item barrier
  • Connection shortcuts with a wallet
  • No more stale statistics in 19c
  • How to TREAT data in a CLOB as JSON
  • Automatically generate audit capture for tables
  • Generating INSERT scripts that run fast!
  • Comparing two database objects for differences
  • Free In-memory in Oracle Database 19c
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 814 other followers
    • Already have a WordPress.com account? Log in now.
    • Learning is not a spectator sport
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...