Table B–4 lists the data schema values for the Oracle database type.
Table B–1 Data Schema Values for the Oracle Database Type
Database Column |
Value |
---|---|
id |
VARCHAR(50) NOT NULL |
name |
VARCHAR(128) NOT NULL |
repomod |
TIMESTAMP |
resourceName |
VARCHAR(128) |
accountName |
VARCHAR(50) |
objectType |
CHAR(2) |
objectName |
VARCHAR(128) |
action |
CHAR(2) |
actionDateTime |
CHAR(21) |
actionStatus |
CHAR(1) |
interface |
VARCHAR(50) |
server |
VARCHAR(128) |
subject |
VARCHAR(128) |
reason |
CHAR(2) |
message |
VARCHAR(255) or CLOB (See note1 at end of table.) |
acctAttrChanges |
VARCHAR(4000) or CLOB |
acctAttr01label |
VARCHAR(50) |
acctAttr01value |
VARCHAR(128) |
acctAttr02label |
VARCHAR(50) |
acctAttr02value |
VARCHAR(128) |
acctAttr03label |
VARCHAR(50) |
acctAttr03value |
VARCHAR(128) |
acctAttr04label |
VARCHAR(50) |
acctAttr04value |
VARCHAR(128) |
acctAttr05label |
VARCHAR(50) |
acctAttr05value |
VARCHAR(128) |
parm01label |
VARCHAR(50) |
parm01value |
VARCHAR(128) or CLOB (See note1 at end of table.) |
parm02label |
VARCHAR(50) |
parm02value |
VARCHAR(128) or CLOB (See note1 at end of table.) |
parm03label |
VARCHAR(50) |
parm03value |
VARCHAR(128) or CLOB (See note1 at end of table.) |
parm04label |
VARCHAR(50) |
parm04value |
VARCHAR(128) or CLOB (See note1 at end of table.) |
parm05label |
VARCHAR(50) |
parm05value |
VARCHAR(128) or CLOB (See note1 at end of table.) |
sequence |
CHAR(19) |
xmlSize |
NUMBER(19,0) |
xml |
BLOB |
The column length limit for these columns is configurable. The default data type is VARCHAR and the default size limit is noted in parentheses. See Audit Log Configuration for information on how to adjust the size limit.