POST
|
Thanks for the info George. You confirmed what I was thinking.
... View more
01-15-2020
10:09 AM
|
0
|
0
|
837
|
POST
|
Thanks for the reply George. There is no issue with the Oracle machine; It's using 400MB space. The database does have a versioning environment and there are lots of tables in the database. Questions: Is the default sde tablespace size of 400MB just a starting point? Can you increase the sde tablespace size from the default 400MB to something larger? Will increasing the tablespace size cause any unseen issues to the function of the gdb
... View more
01-15-2020
09:52 AM
|
0
|
2
|
837
|
POST
|
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
... View more
01-15-2020
08:54 AM
|
0
|
4
|
945
|
IDEA
|
The ability to open a connection to an ArcGIS Online organization from a stand-alone python script without having to open ArcMap application that is already logged into ArcGIS Online. arcpy.SignInToPortal_server command does not work in version 10.5.1
... View more
02-01-2019
03:16 PM
|
1
|
1
|
255
|
POST
|
Hi Vince, We have been using user schema gdbs where the for years with no issues and wish to continue doing so. The problem now is that the only user who can add data to the user schema gdb is the user schema user. When that user is created their default tablespace is set to the tablespace that holds the gdb system tables for the user schema gdb not the master gdb. I want to know if I should change the user schema user's default tablespace to point to a different tablespace so that no data objects are created in the user schema gdb system tables tablespace or should I just change all of the dbtune DEFAULTS keyword parameters to point to different tablespaces than the user schema user gdb system table tablespace. Thoughts? Thanks, Calli
... View more
03-09-2016
06:52 AM
|
0
|
2
|
699
|
POST
|
Thanks for the reply George. The geodatabase administrator name is testgdb and tablespace used in the Create Enterprise Geodatabase GP tool is named testgdb and is the default tablespace for user testgdb. Can you tell me if by modifying the dbtune DATA_DICTIONARY and DEFAULTS keyword parameters to point to the tablespaces other than the user schema user default tablespace, which stores the gdb system tables, no data objects will be created in the gdb system table tablespace. The attached text file contains the what I think the dbtune DATA_DICTIONARY and DEFAULTS keyword parameters should be set to based on your response. Let me know what you think?
... View more
03-08-2016
04:03 PM
|
0
|
0
|
699
|
POST
|
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?
... View more
03-04-2016
08:15 PM
|
0
|
8
|
3487
|
POST
|
We currently do not have the resources (licensing and location) to create any new database instances. Can you provide more detail on how to perform validity checks and how to run a validation upgrade?
... View more
04-24-2015
11:26 AM
|
0
|
1
|
237
|
POST
|
Are there any issues to be aware of when upgrading ArcSDE v9.3.1 - Oracle 11.2.0.3 to ArcSDE v10.2x?
... View more
04-24-2015
10:48 AM
|
0
|
3
|
3320
|
Title | Kudos | Posted |
---|---|---|
1 | 01-31-2019 02:05 PM | |
1 | 02-01-2019 03:16 PM |
Online Status |
Offline
|
Date Last Visited |
yesterday
|