What datatypes are used by the Symantec DLP schema?

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:

Environment

15.x

Resolution

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

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

TIMESTAMP(3)
LONG
TIMESTAMP(6)
FLOAT
NUMBER
CLOB
CHAR
DATE
VARCHAR2
BLOB