Advanced Oracle PL/SQL Developer's Guide - Second Edition

Working with LOBs

Now that we know the benefits of Oracle SecureFiles, let's illustrate how to work with the LOB data in the Oracle Database. In our case study, you will see the comparison between BasicFiles and SecureFiles.

Let's first verify the setting of the db_securefile initialization parameter:

conn sys/oracle as SYSDBA
show parameter db_securefile

NAME             TYPE      VALUE
---------------- --------- ---------
db_securefil     string    PREFERRED

We will use the default setting of the parameter because it allows the creation of a SecureFile on the ASSM tablespace and the behavior can be overridden by explicitly specifying BasicFile.

For testing purposes, let's create two tablespaces with different segment space management. The TBS_BASIC tablespace is a manually ...