Queries are showing that the LOB files were not converted to Secure Files after correctly following the instructions

book

Article ID: 184768

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Cause

If there is a message that the conversion operation did indeed process succesfully, the most likely cause of the problematic query result is that you were logged in with the "sys" user account when running the query. This account will not show the output that we are looking for, which will be tied to the "protect" account.

Environment

The specific issue in this article has been observed when following "Solution #1" to convert the LOB table to SecureFiles in Oracle 11G ... however, it may also apply when switching to SecureFiles with other supported Oracle versions as well.

Resolution

If you are logged in with the "sys" user account (and the conversion operation did say that it succeeded when you ran it) the problem with the query results can be resolved by simply logging out, logging back in as the Protect user, and rerunning the query (select table_name, securefile from user_lobs where table_name like '%LOB%';)