1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Difference between NEVER and IGNORE setting in DB_SECUREFILES

Discussion in 'SQL PL/SQL' started by jamuna_j, Nov 1, 2012.

  1. jamuna_j

    jamuna_j Active Member

    Likes Received:
    Trophy Points:
    I am confused between the NEVER and IGNORE settings on the creation of Securefiles, which is indicated by the DB_SECUREFILES parameter in init.ora.

    The Oracle documentation says -

    Another part of the document says -

    So, if I give NEVER, securefiles are going to function like basicfiles. And yes, the operations which are specific to securefiles will be invalid and throw an exception.

    Now if I give IGNORE, what is new? From what I understand, the only difference is the securefile exceptions thrown in NEVER will not be present in IGNORE.

    Is there any other difference in terms of Creation or Storage between the two?

    Thanks in advance! :)
  2. zargon

    zargon Community Moderator Forum Guru

    Likes Received:
    Trophy Points:
    Aurora, CO
    None that I can see. You appear to have the slight difference between the two options correctly described.