AnsweredAssumed Answered

What would cause the oracle sde table space used size to reach 99%

Question asked by cbroome on Jan 15, 2020
Latest reply on Jan 15, 2020 by cbroome

The sde space has 400 MB allocated to it and is currently indicating that 99.4 percent of the storage capacity is used.  The dbtune file has been setup so that no spatial data can be stored in the sde tablespace; the sde table space only contains the ArcSDE system tables that make sde run.  The sde user schema contains the following system privileges:

  • CREATE PROCEDURE
  • CREATE SEQUENCE
  • CREATE SESSION
  • CREATE TABLE
  • CREATE TRIGGER
  • ALTER ANY INDEX
  • ALTER SYSTEM
  • ANALYZE
  • SELECT ANY DICTIONARY
  • UNLIMITED TABLESPACE

 

The oracle database version is 12.1.2.0 and the ArcSDE version is 10.5.1

Outcomes