create table AUDSYS.AUD$UNIFIED
(
inst_id NUMBER,
audit_type NUMBER,
sessionid NUMBER,
proxy_sessionid NUMBER,
os_user VARCHAR2(128),
host_name VARCHAR2(128),
terminal VARCHAR2(30),
instance_id NUMBER,
dbid NUMBER,
authentication_type VARCHAR2(1024),
userid VARCHAR2(128),
proxy_userid VARCHAR2(128),
external_userid VARCHAR2(1024),
global_userid VARCHAR2(32),
client_program_name VARCHAR2(48),
dblink_info VARCHAR2(4000),
xs_user_name VARCHAR2(128),
xs_sessionid RAW(33),
entry_id NUMBER not null,
statement_id NUMBER not null,
event_timestamp TIMEStamP(6) not null,
action NUMBER not null,
return_code NUMBER not null,
os_process VARCHAR2(16),
transaction_id RAW(8),
scn NUMBER,
execution_id VARCHAR2(64),
obj_owner VARCHAR2(128),
obj_name VARCHAR2(128),
sql_text CLOB,
sql_binds CLOB,
application_contexts VARCHAR2(4000),
client_identifier VARCHAR2(64),
new_owner VARCHAR2(128),
new_name VARCHAR2(128),
object_edition VARCHAR2(128),
system_privilege_used VARCHAR2(1024),
system_privilege NUMBER,
audit_option NUMBER,
object_privileges VARCHAR2(35),
role VARCHAR2(128),
target_user VARCHAR2(128),
excluded_user VARCHAR2(128),
excluded_schema VARCHAR2(128),
excluded_object VARCHAR2(128),
current_user VARCHAR2(128),
additional_info VARCHAR2(4000),
unified_audit_policies VARCHAR2(4000),
fga_policy_name VARCHAR2(128),
xs_inactivity_timeout NUMBER,
xs_entity_type VARCHAR2(32),
xs_target_principal_name VARCHAR2(128),
xs_proxy_user_name VARCHAR2(128),
xs_datasec_policy_name VARCHAR2(128),
xs_schema_name VARCHAR2(128),
xs_callback_event_type VARCHAR2(32),
xs_package_name VARCHAR2(128),
xs_procedure_name VARCHAR2(128),
xs_enabled_role VARCHAR2(128),
xs_cookie VARCHAR2(1024),
xs_ns_name VARCHAR2(128),
xs_ns_attribute VARCHAR2(4000),
xs_ns_attribute_old_val VARCHAR2(4000),
xs_ns_attribute_new_val VARCHAR2(4000),
dv_action_code NUMBER,
dv_action_name VARCHAR2(30),
dv_extended_action_code NUMBER,
dv_grantee VARCHAR2(128),
dv_return_code NUMBER,
dv_action_object_name VARCHAR2(128),
dv_rule_set_name VARCHAR2(90),
dv_comment VARCHAR2(4000),
dv_factor_context VARCHAR2(4000),
dv_object_status VARCHAR2(1),
ols_policy_name VARCHAR2(128),
ols_grantee VARCHAR2(128),
ols_max_read_label VARCHAR2(4000),
ols_max_write_label VARCHAR2(4000),
ols_min_write_label VARCHAR2(4000),
ols_privileges_granted VARCHAR2(128),
ols_program_unit_name VARCHAR2(128),
ols_privileges_used VARCHAR2(128),
ols_string_label VARCHAR2(4000),
ols_label_component_type VARCHAR2(12),
ols_label_component_name VARCHAR2(30),
ols_parent_group_name VARCHAR2(30),
ols_old_value VARCHAR2(4000),
ols_new_value VARCHAR2(4000),
rman_session_recid NUMBER,
rman_session_stamp NUMBER,
rman_operation VARCHAR2(20),
rman_object_type VARCHAR2(20),
rman_device_type VARCHAR2(5),
dp_text_parameters1 VARCHAR2(512),
dp_boolean_parameters1 VARCHAR2(512),
direct_path_num_columns_loaded NUMBER,
rls_info CLOB,
ksacl_user_name VARCHAR2(128),
ksacl_service_name VARCHAR2(512),
ksacl_source_location VARCHAR2(48),
con_id NUMBER,
protocol_session_id NUMBER,
protocol_return_code NUMBER,
protocol_action_name VARCHAR2(32),
protocol_userhost VARCHAR2(128),
protocol_message VARCHAR2(4000)
)
partition by range (EVENT_TIMEStamP)
(
partition SYS_P348 values less than (TIMEStamP' 2021-06-01 00:00:00')
tablespace SYSAUX
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
)
);
-- Add comments to the table
comment on table AUDSYS.AUD$UNIFIED
is 'Unified Audit internal table, which holds the unified audit records';