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

June 24, 2020 Uncategorized

How to migrate to SECUREFILE with DataPump

These tweets somewhat befuddle me. Because to be honest, if I no matter if I say “Yes” or “No” ,

Continue reading

October 17, 2018 Uncategorized

Compressed LOB–my table got bigger?

We had an interesting question on AskTOM the other day about LOB compression. Someone was very concerned that after applying

Continue reading

October 13, 2018 Uncategorized

LOBs vs Data – when compression occurs

Just a quick tip for SECUREFILE lobs. You may be familiar with basic compression on data in tables. It is

Continue reading

September 24, 2018 Uncategorized

Datatype conversion laziness … yet another reason

I’ve got two words to describe my thoughts on being lazy with data types …. JUST DON’T! There’s been many

Continue reading

January 25, 2018 Uncategorized

Those pesky LONG columns

There was a time, many moons ago when CLOB, BLOB and BFILE did not exist as data types. So if

Continue reading

November 22, 2017 Uncategorized

LOBs from afar

This has always been a nuisance.  There you are – getting all the bells and whistles with LOBs…until a database

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 1, 2016 Uncategorized

Securefile in 12c – part 2

In a previous post, I noted that the parameter db_securefile changes from PERMITTED in 11g, to PREFERRED in 12c.  Jonathan

Continue reading

March 1, 2016 Uncategorized

Loading LOB from a file

I observed this idiosyncracy recently when loading some lob from external files using PL/SQL: First we’ll create a file to

Continue reading

January 20, 2016 Uncategorized

Converting LONG to CLOB

Some folks still are stuck with LONG columns, and are keen to move to LOB.  Since version 9, we’ve had

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

    • Bringing Multimedia back into 19c!
    • How do I stop the use of TRUNCATE
    • Why I blog
    • Let's talk about Techiquette
    • Adding APEX 23.1 to your Database Free VM
    • How to do a GRANT on an entire schema
    • How to TREAT data in a CLOB as JSON
    • Implementing dynamic partitions AND subpartitions
    • How to generate random unique values
    • Is "fragmentation" still a dirty word?
    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
     

    Loading Comments...