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

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 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

soapy hands washing under a running tap
March 2, 2022 Uncategorized

Cleaner DDL than DBMS_METADATA

Most of us with any kind of longevity in the Oracle world will remember the days when we wrote our

Continue reading

June 14, 2021 Uncategorized

Get complete DDL for a schema

There are plenty of tools out there that you can use to get DDL scripts for various objects in the

Continue reading

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

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.

Tweets by connor_mc_d

    Top Posts & Pages

    • The new forums
    • How to do a GRANT on an entire schema
    • The simple fix to date queries
    • How to TREAT data in a CLOB as JSON
    • Generating INSERT scripts that run fast!
    • Connection shortcuts with a wallet
    • Why you keep getting "ORA-01653: unable to extend table"
    • How to generate random unique values
    • No more stale statistics in 19c
    • Digging deeper into SQL under APEX
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 848 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...