O'Reilly logo

Advanced Oracle PL/SQL Developer's Guide - Second Edition by Saurabh K. Gupta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required