Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Migration to SecureFiles using Online Table Redefinition in Oracle 11gR2

Migration to SecureFiles using Online Table Redefinition in Oracle 11gR2

Oracle introduced SecureFiles in Oracle 11g to enhance existing LOB types. The new SecureFiles concept and architecture is entirely new engineered LOBs in comparison to the old LOBs existing prior to Oracle 11g that are now referred to as Basic Files. Information about SecureFiles in Oracle 11gR2 can be found here. Information about how to use secure files can be found here. Note that for compatibility reasons Basic Files functionality is supported.

  1. Environment is set by the value of DB_SECUREFILE parameter controlling if LOBS are created as Basicfiles or SecureFiles.

    The db_securefile parameter is set as show below.

    SQL> show parameter db_securefile

    NAME TYPE VALUE

    ———————————— ———– ——————————

    db_securefile string PERMITTED

    SQL>

    Values than db_securefile parameter can take are:

    PERMITTED – Allows the DBA to create SecureFiles

    NEVER – disallow creation in the future ( after the parameter is set to this value)

    ALWAYS – attempts to create all LOBs as SecureFiles LOBs but creates any LOBs not in ASSM tablespaces as BasicFiles LOBs, unless the SECUREFILE parameter is explicitly specified. Any BasicFiles LOB storage options specified are ignored, and the SecureFiles LOB defaults are used for all storage options not specified.

    IGNORE – ignores SecureFiles LOB options and SECUREFILE keyword. LOBS are created as BasicFiles. Continue reading

May 11, 2011 Posted by | oracle | Leave a comment