Is the sde database only for storing the ArcSDE and geodatabase system tables?
No, you can store user data in the sde database. However, from an administration standpoint, you may want to keep the sde database for just the ArcSDE and geodatabase system tables. You can load data with the same names into separate databases but client applications may have problems with this if they do not fully qualify their table names. NOTE: ArcInfo 8.0.2 users: You must connect directly to a database to load data or to alter a table (ddl operations). You can connect to any database to edit data in any other database (dml operations).
Related Questions
- Does the system start computing and storing the aggregated ART statistics values in the OLAP database before I create ART Groups?
- Is anything done to system tables (for example, Master database) during architecture installation?
- Is the sde database only for storing the ArcSDE and geodatabase system tables?
