13.1 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 OBAPI schema

  alter user <OBAPI_SCHEMA> quota unlimited on <OBAPI_AUDIT_INDEX_TABLESPACE>;

• Drop and create below index by mapping the newly created tablespace

  • OBAPI_Installer\installables\db\OBAPI\ddl\oracle\audit\ IDX_DIGX_AL_API_AUDIT_LOGGING.sql

  • OBAPI_Installer\installables\db\OBAPI\ddl\oracle\audit\ IDX_DIGX_AL_API_AUDIT_LOG_HIST.sql

  • OBAPI_Installer\installables\db\OBAPI\ddl\oracle\audit\IDX_DIGX_AL_AUDIT_LOGGING.sql

  • OBAPI_Installer\installables\db\OBAPI\ddl\oracle\audit\ IDX_DIGX_AL_AUDIT_LOGGING_1.sql

  • OBAPI_Installer\installables\db\OBAPI\ddl\oracle\audit\ IDX_DIGX_AL_AUDIT_LOGGING_2.sql

  • OBAPI_Installer\installables\db\OBAPI\ddl\oracle\audit\ IDX_DIGX_AL_AUDIT_LOGGING_3.sql

  • OBAPI_Installer\installables\db\OBAPI\ddl\oracle\audit\ IDX_DIGX_AL_AUDIT_LOGGING_4.sql

  • OBAPI_Installer\installables\db\OBAPI\ddl\oracle\audit\IDX_DIGX_AL_AUDIT_LOGGING_DETAILS.sql