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

  • OBDX_Installer\installables\db\OBDX\ddl\oracle\audit\IDX_DIGX_AL_AUDIT_LOGGING_DETAILS.sql