My Oracle Support Banner

Creating RCU Schemas For Oracle Analytics Server 2023 In The Oracle Database Standard Edition Fails With Error: ORA-00439 Online Index Feature Not Enabled (Doc ID 2969846.1)

Last updated on AUGUST 23, 2023

Applies to:

Oracle Analytics Server - Version 2023 to 2023 [Release 23]
Information in this document applies to any platform.

Symptoms

On an Oracle Analytics Server (OAS) 2023 installation ...

Creating the RCU Schemas in an Oracle Database Standard Edition instance fails and the following error is observed in the RCU log file when creating the <Prefix>_BIPLATFORM schema:

Couldn't create schema!
Error while creating index W_ETL_REPOS_P1.

ORA-00439: feature not enabled: Online Index

Note: 

This issue is not encountered when creating the OAS 2023 RCU Schemas in an Oracle Database Enterprise Edition instance.

This issue is not encountered when creating the the RCU Shcemas for earlier releases of OAS (2022 / 6.4, etc.) in an Oracle Database Standard Edition instance.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.