Learning is not a spectator sport

CLOBS, from 11g to 12c

November 20, 2015

1–2 minutes

If you are a regular user of LOB’s in the database, take care when you switch from 11g to 12c. Notice the subtle difference:

In 11g, you are permitted to, and recommended to, use SECUREFILE lobs, but they are not the default


SQL> select name, value
  2  from v$parameter
  3  where  name = 'db_securefile';

NAME                                     VALUE
---------------------------------------- ---------------
db_securefile                            PERMITTED

In12c, SECUREFILE lobs will be the default.



SQL> select name, value
  2  from v$parameter
  3  where  name = 'db_securefile';

NAME                                     VALUE
---------------------------------------- ---------------
db_securefile                            PREFERRED

This change should be beneficial, because SECUREFILE lobs are the newer and more functional implementation, but just be aware that the default has changed between versions.

5 responses to “CLOBS, from 11g to 12c”

Noons

November 21, 2015 at 5:59 am

Let’s hope the old format is stll fully supported, otherwise upgrading to 12c is going to be a nightmare for a lot of folks…

Reply
Jonathan Lewis

August 31, 2016 at 7:07 pm

Lazy question:

Will it be possible to have a partitioned table where the old partitions were using Basicfiles and the new partitions can use securefiles ?

Reply
1. connormcdonald
  
  September 1, 2016 at 2:44 pm
  
  A blog post to come …. an interesting result found
  
  Reply
Fairlie

September 1, 2016 at 1:58 pm

Well the syntax certainly is supported.
Will let you know if I hit some 600s though 🙂

Reply
Securefile in 12c – part 2 | Learning is not a spectator sport

September 1, 2016 at 10:10 pm

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

Reply