What datatypes are used by the Symantec DLP schema?

book

Article ID: 160304

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

While Oracle is capable of supporting many different datatypes, the Symantec DLP schema makes use of  the following:

Resolution

SQL> select distinct data_type from dba_tab_columns where owner='PROTECT';

DATA_TYPE
--------------------------------------------------------------------------

LONG
TIMESTAMP(6) WITH TIME ZONE
TIMESTAMP(6)
NUMBER
CLOB
DATE
VARCHAR2
BLOB