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

March 8, 2019 Uncategorized

External table preprocessor on Windows

There are plenty of blog posts about using the pre-processor facility in external tables to get OS level information available

Continue reading

February 15, 2019 Uncategorized

The death of UTL_FILE – part 2

I wrote a post a while back call “The Death of UTL_FILE”, and probably because of it’s click-bait title I

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

November 10, 2015 Uncategorized

A new line on NEWLINE

Recently I was doing a simple external table load using a CSV file, but was getting an interesting error. My

Continue reading

January 2, 2015 Uncategorized

Slow external table access

We had an interesting issue on 12.1.0.1, where users were reporting very slow performance on queries to external tables. When

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.

Tweets by connor_mc_d

    Top Posts & Pages

    • Bringing Multimedia back into 19c!
    • How do I stop the use of TRUNCATE
    • Adding APEX 23.1 to your Database Free VM
    • How to do a GRANT on an entire schema
    • Is "fragmentation" still a dirty word?
    • Implementing dynamic partitions AND subpartitions
    • No more stale statistics in 19c
    • DBMS_JOB and 19c - code changes needed
    • When can I use SQL Macros?
    • Some "must-have" ideas for your next meetup
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 863 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