Resolve an issue with Tablespace becoming full in Spectrum GeoCoding

Product Feature: Spectrum Server 9.0 SP1
Oracle Spatial Server 11g
Operating System: Windows 2008
 

Issue

In Spectrum Geocoding, the SYSAUX tablespace becomes full.

This causes Spectrum to stop.

Cause

This issue is related to Oracle DB. SYSAUX tablespace is used by system tables in Oracle and has its own mechanism of cleaning temporary files.

Resolution

UPDATED: October 23, 2017
The workaround for this issue is to restart Spectrum.

The issue is with Oracle DB so contact Oracle Support for a permanent resolution to this issue.