Database Error Messages

OCI-12955

unable to acquire extents from other instances of the cluster for temporary tablespace string

Cause

The current instance was out of space in the temporary segment belonging to the specified temporary tablespace and was unable to acquire unused extents from other instances of the cluster. This might happen when the system monitor process (SMON) on an instance was busy and was unable to cleanup unused extents from the temporary tablespace.


Action

  1. Check if the system monitor process (SMON) is busy or in a hung state on other instances of the cluster.
  2. Use ALTER TABLESPACE ADD DATAFILE statement to add one or more

files to the tablespace indicated.