• 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: ddl

March 10, 2021 Uncategorized

DBMS_METADATA – hitting its limit

I was helping out a customer today with what they thought was a bug in DBMS_METADATA. They were using it

Continue reading

July 22, 2020 Uncategorized

DDL gets my goat

First things first. If you are not familiar with the term “gets my goat” then you can find a definition

Continue reading

August 20, 2019 Uncategorized

DDL invalidates your SQL right ?

I stumbled upon this post by optimizer guru Nigel Bayliss last week, so please have a read of that first

Continue reading

April 24, 2019 Uncategorized

Take care with automatic indexes

This one came in via an AskTOM question. You need to be careful when disabling constraints that are underpinned by

Continue reading

April 24, 2019 Uncategorized

Capture all DDL run on a database instance

I posted a video a couple of days ago showing a trigger mechanism to customize the capture of DDL that

Continue reading

June 25, 2018 Uncategorized

DDL for constraints – subtle things

The DBMS_METADATA package is very cool. I remember the days of either hand-crafting DDL statements based on queries to the

Continue reading

November 1, 2017 Uncategorized

Parsing freeform data in flat files

SQL loader is a very cool utility that has existed for a long time within Oracle to load flat files

Continue reading

September 18, 2017 Uncategorized

LOBs and tiny typos

This one caught me out – I was racing around looking for bugs, or parameter files, or hidden settings that

Continue reading

September 7, 2017 Uncategorized

Please keep your foreign keys

I came across an interesting blog post the other day about whether databases should be (declaratively) enforcing the foreign key

Continue reading

February 26, 2017 Uncategorized

Better to be safe than sorry…

I’ve always been worried about taking a script that is fine to run in my non-production environments (in particular a

Continue reading

Posts navigation

1 2 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"
  • No more stale statistics in 19c
  • APEX 20.2 comes to town (well, to my PC)
  • LOBs from afar
  • My APEX was fine and then it wasn't
  • Updating indexes with partition maintenance
  • Pluggable database and restricted sessions
  • NULL's vs NOT NULL's and Performance
  • Generating INSERT scripts that run fast!
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
Cancel

 
Loading Comments...
Comment
    ×