My Oracle Support Banner

ORA-372 On Temporary Tablespace Though It Is ONLINE Status (Doc ID 2661465.1)

Last updated on APRIL 02, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 19.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

ORA-372 is occurred on temporary tablespace though it is ONLINE status :

ORA-00372: file 999 cannot be modified at this time
ORA-01110: data file 999: '/<PATH>/temp01.dbf'

About ORA-372 :


However, DBA_TABLESPACES.STATUS of temporary tablespace is neither "OFFLINE" nor "READ ONLY", but "ONLINE".

Changes

none. 

 

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
Changes
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.