Database Security Products (MOSC)

MOSC Banner

External table datapump column encryption not working

Standalone, 19.17, Oracle Linux

This create-table ...

create table ext_eventlog

(

  EVENTLOG_TYPE,

  EVENTLOG_DATETIME,

  EVENTLOG_SOURCE,

  EVENTLOG_CATEGORY,

  EVENTLOG_EVENT,

  EVENTLOG_USER,

  EVENTLOG_TEXT encrypt using 'AES256' identified by "wutwut",

  EVENTLOG_ID,

  EVENTLOG_APP,

  EVENTLOG_SERVER

)

  organization external(

     type oracle_datapump

     default directory archiver_dir

     location('eventlog.dmp')

  )

as

select *

from asset.eventlog

where rownum <= 10


... runs without error and, does NOT produce a file with encrypted values in the indicated column. Additionally, a second external-table created without the column-encrypt clause reads the file without issue. Sooo, not encrypted.

The tables has no TDE-encrypted columns. The table exists in a TDE-encrypted tablespace.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center