AnsweredAssumed Answered

User Schema geodatabase in Oracle 12.1.0.2

Question asked by cbroome on Mar 4, 2016
Latest reply on Aug 26, 2016 by vangelo-esristaff

I have set up a ArcSDE v10.2.1 user schema (child) geodatabase (gdb)in Oracle 12.1.0.2 and because the user schema user is the only client who can add gis data to the database I am a bit confused on what to set the user's default tablespace to after the gdb has been created.  Right now it's set to the tablespace that houses the ArcSDE system tables for the child gdb.  I suspect that should not be the case because there is the chance that gis spatial data could be added to the ArcSDE system tables tablespace.   My question is this should the default tablespace for the user schema user be set to another tablespace that has been set up to store the gis business data for that user? and should the user schema ArcSDE system tables tablespace be granted unlimited quota?

Outcomes