My Oracle Support Banner

AW Cube Build Fails With Error ORA-00372: File 2003 Cannot Be Modified At This Time (Doc ID 1543557.1)

Last updated on NOVEMBER 04, 2019

Applies to:

Oracle OLAP - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product.  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

A critical cube that supports our Store Dashboards failed with the following error.

Wed Feb 27 06:57:49 2013
....
ORA-12012: error on auto execute of job "<USER NAME>"."JOB$_435354"
ORA-37162: OLAP error
XOQ-00703: error executing OLAP DML command "(UPDATE <USER_NAME>.<CUBE NAME> : ORA-37605: error during OLAP AW UPDATE
ORA-00372: file 2003 cannot be modified at this time
ORA-01110: data file 2003: '+DATA/tempfile/temp_olap.397.766073837')"
ORA-06512: at "SYS.DBMS_CUBE", line 234
ORA-06512: at "SYS.DBMS_CUBE", line 316
ORA-06512: at line 1

Changes

 

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!


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