OBDX Product – Best Practice

Tablespace for AUDIT INDEX

The index’s used by AUDIT table should be moved into new tablespace from current AUDIT tablespace.
Follow below steps

• Create a new tablespace
• Give quota to OBDX schema
• alter user <OBDX_SCHEMA> quota unlimited on <OBDX_AUDIT_INDEX_TABLESPACE>;
• Drop and create below index by mapping the newly created tablespace
• OBDX_Installer\installables\db\OBDX\ddl\oracle\audit\ IDX_DIGX_AL_API_AUDIT_LOGGING.sql
• OBDX_Installer\installables\db\OBDX\ddl\oracle\audit\ IDX_DIGX_AL_API_AUDIT_LOG_HIST.sql
• OBDX_Installer\installables\db\OBDX\ddl\oracle\audit\IDX_DIGX_AL_AUDIT_LOGGING.sql
• OBDX_Installer\installables\db\OBDX\ddl\oracle\audit\ IDX_DIGX_AL_AUDIT_LOGGING_1.sql
• OBDX_Installer\installables\db\OBDX\ddl\oracle\audit\ IDX_DIGX_AL_AUDIT_LOGGING_2.sql
• OBDX_Installer\installables\db\OBDX\ddl\oracle\audit\ IDX_DIGX_AL_AUDIT_LOGGING_3.sql
• OBDX_Installer\installables\db\OBDX\ddl\oracle\audit\ IDX_DIGX_AL_AUDIT_LOGGING_4.sql

:

Back