Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About yockee
yockee
Frequent Contributor
since
02-21-2019
02-04-2026
221
Posts created
50
Kudos given
5
Solutions
17
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(0 Idea Submissions)Latest Contributions by yockee
|
POST
|
@MarceloMarques Thanks.. Any Idea how to rebuild spatial index using query? I am able to build attribute index using query, but I just can not find any articles on building spatial index using query
... View more
10-03-2022
12:20 AM
|
0
|
3
|
14715
|
|
POST
|
Hi @MarceloMarques The "Rxxxx_SDE_ROWID_UK" is greyed out and I see it's status is "UNUSABLE". If its Unusable, how can I make it usable again ? I want to delete and rebuild it in order to make it usable again.. Thanks
... View more
09-26-2022
07:38 PM
|
0
|
1
|
14742
|
|
POST
|
Hi, I am using Oracle 19c and ArcGIS Enterprise 10.9 Recenty I move some Feature Class into another tablespace. I observe the indexes using query : SELECT table_name, index_name, index_type, status, NUM_ROWS FROM DBA_INDEXES WHERE STATUS='UNUSABLE' AND owner = 'SDE' The Normal and Domain indexes become "unusable". I know I can rebuild Indexes using ArcGIS Pro but I think its to tiresome becasue I have 1000 feature classes. I prefer using phyton script or query / plsql. Is there anyone here can help or at least point me to a direction? Moreover, I tried to delete the attribute Index. But the button is greyed out. Why ? I can rebuild the spatial index just fine. See the picture below: How can I delete and then rebuild the Attribute Index again with the same name (or with deifferent name, its fine) ? Thanks
... View more
09-26-2022
02:15 AM
|
0
|
16
|
18107
|
|
POST
|
Hi, I want to move ALL user data into different tablespace, separating them from SDE System files. I just want to move the base table, without moving the indexes etc. is doing it via ArcSDE Configuration keyword the same as issuing this particular command : ALTER TABLE SDE.ROAD_DATA MOVE TABLESPACE DATAUSER1; ? I have done a little research, by issuing that ALTER TABLESPACE command, all the functionality are still normal, such as : editing from arcgis pro, updating attribute via feature service and editing the shape via feature service, also all the viewing (pan, zoom), select from Arcgis pro are still working normally. Are these indicators sufficient to qualify what I am doing is correct ? many thanks @mody_buchbinder @George_Thompson @KimberlyGarbade Thanks
... View more
09-25-2022
08:01 PM
|
0
|
1
|
2911
|
|
POST
|
So, if the reason of separating tablespace is based on avoiding the system table to fill up, then it is not exactly correct because the tablespace, where system table resides, can be set to automatically increment its size. Correct ?
... View more
08-29-2022
06:15 AM
|
0
|
1
|
2464
|
|
POST
|
Hi, I have successfully moving one of my feature class into another tablespace. Previously, SDE system tables and user data are in one tablespace. It turns out that Its not just the feature classes that can be moved into another tablespace, but the indexes as well. going further, there are LOB column too. Questions are : 1. When I move the user data (feature class) to another tablespace, do I have to move the indexes and LOB column ? There are, generally, 3 kinds of indexes : Domain, Normal and LOB indexes. NORMAL index is easy to move, but not for the Domain and Lob indexes. I just want to move them all (all indexes, table, and LOB column) 2. What are the associating DBTUNE keyword for that point number 1 ? 3. Is it safe for the integrity of the database to move all the indexes and the LOB column ? Oracle 19c, ArcGIS Pro 2.6, SDE 10.9, Geometry storage : ST_GEOMETRY Thanks. Need your advice.
... View more
08-29-2022
06:10 AM
|
0
|
0
|
883
|
|
POST
|
Hi, I am wondering the reason of separating user data tablespace from SDE system tablespace. I know its better to separate them to avoid SDE tablespace from filling up. But, what if the SDE tablespace has space autoincrement turned on ? How does the separation of tablespace relate to database backup ? Would it be easier to backup and restore when they are separated or otherwise ? Need your advice
... View more
08-28-2022
09:16 PM
|
0
|
5
|
2506
|
|
POST
|
@George_Thompson and all, Is it better to separate tablespace for SDE system tables and user tables onto different disk (physically) or the same disk ?
... View more
07-24-2022
08:53 PM
|
0
|
0
|
2976
|
|
POST
|
Hi all, It turns out that this works perfectly well, even for oracle too : https://community.esri.com/t5/arcgis-enterprise-documents/update-arcgis-server-services-after-sql-server/ta-p/1181710 Thanks guys
... View more
07-02-2022
09:21 PM
|
1
|
0
|
3246
|
|
POST
|
yes George thanks. I might try this. If I change the TNS, It doesn't have any impact right to the integrity of the whole system ? I am just being very very overly cautious.. 🙂 thanks
... View more
06-29-2022
06:44 PM
|
0
|
0
|
3264
|
|
POST
|
Yes, I use TNS. You mean I use the same TNS but with different Host and ServiceName (DB) name ? maybe there is equivalent of this procedure on Oracle. thanks
... View more
06-29-2022
01:47 AM
|
0
|
2
|
3280
|
|
POST
|
Hi, I need some help. I am in the middle of upgrading ORACLE (from 11g to 19c). The upgrade was success, all FC are still intact and operation is absolutely normal from ArcgisPro 2.8 point of view. But, there is a problem for map services! How do I repoint all the map services to the new data source in the fastest way as possible ? I have like 250 map services and I do not want to do it manually. I know how to do it manually, by opening the MAPX file and repoint all the FCs to their new source. Although its guaranteed success, But...Its just too much with 250 services. Can anyone help with advice or point me to the right direction ? My setup : Geodatabase 10.9.1.2.9, Oracle 19c, ArcGIS Pro 2.8, Geoportal and ArcGIS Server. There are Feature Services, Map Services and image service. Thank you so much.
... View more
06-28-2022
08:18 AM
|
0
|
6
|
3320
|
|
POST
|
Hi Vince, You said "I generally create several different tablespaces with different UNIFORM extent..." How do you know which table goes into which tablespace ? How do you decide that this table goes into that tablespace ? I know that I can use SDEDBTUNE keyword to redirect the storage. But isn't it cumbersome if you have a lot of feature classes (I have like couple of thousands FCs) ? Thanks. Need your advice
... View more
06-27-2022
05:46 AM
|
0
|
0
|
2355
|
|
POST
|
Hello, I have KEYSET tables around 30K tables and I am preparing to delete them all. Currently, I used scheduled job that drops some 1000 tables that runs once at midnite. Some curiosities : 1. What cause the formation of these tables ? One cause is that it is needed when joining tables with > 100 records match. 2. Does a process from Map / Feature Service create these tables too ? Say there is a map service that join 2 tables with more than 100 records match. Do this create KEYSET table ? 3. If I drop all of them, will it have any adverse effect on the whole workflow / infrastructure. Will the geodb still be accessible ? Will map services (if it has any effect on map services) still working properly ? I have seen some some readings telling that dropping all Keysets are just fine. I have also follow the instruction on Dropping keyset given by Esri. Many thanks
... View more
06-12-2022
11:26 PM
|
0
|
0
|
837
|
|
POST
|
Hi, The KEYSET tables grow so large, around 33000 tables (they never been deleted since the geodb was created). Some questions : 1. What are the processes that trigger it ? One thing for sure is during the join for >100 records. Does JOIN process from web apps trigger this too ? 2. Do I need to reclaim the tablespace after they have been dropped ? But the total amount of their size are 0. Here is the query I use to see their total size : SELECT segment_name,segment_type, sum(bytes/1024/1024/1024) GB FROM dba_segments WHERE owner = 'SDE' AND segment_name LIKE 'KEYSET_%' group by segment_name,segment_type; Thanks @RiccardoKlinger
... View more
05-30-2022
06:21 AM
|
0
|
0
|
3115
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 11-25-2024 12:33 AM | |
| 1 | 11-21-2025 12:57 AM | |
| 1 | 11-12-2024 08:22 PM | |
| 1 | 10-13-2024 11:55 PM | |
| 1 | 02-25-2022 05:49 AM |
Activity Feed
- Posted Inconsistent reading of records between Arcgis Pro and rdbms admin tool on ArcGIS Enterprise Questions. 02-01-2026 11:34 PM
- Posted Re: Service behaves differently with shared instance pool vs. dedicated instances on Publishing and Managing Services Questions. 01-27-2026 08:48 PM
- Posted Server Statistics between Shared and Dedicated Instance on ArcGIS Enterprise Questions. 01-25-2026 08:09 PM
- Posted Re: Postgresql trigger to maintain coloumn uniqueness on ArcGIS Field Maps Questions. 01-25-2026 07:19 PM
- Posted Estimating components and cost of AGOL for Survey using Field Map on ArcGIS Field Maps Questions. 01-21-2026 07:44 PM
- Posted Re: Postgresql trigger to maintain coloumn uniqueness on ArcGIS Field Maps Questions. 12-12-2025 01:30 AM
- Kudoed Re: the mechanism of arcade Attribute Validation for TimWestern. 12-11-2025 10:50 PM
- Posted Re: Postgresql trigger to maintain coloumn uniqueness on ArcGIS Field Maps Questions. 12-10-2025 10:11 PM
- Posted Re: Postgresql trigger to maintain coloumn uniqueness on ArcGIS Field Maps Questions. 12-10-2025 06:55 PM
- Kudoed Re: Attribute Validation / Calculation using Arcade or Database Trigger for RPGIS. 12-10-2025 06:29 PM
- Got a Kudo for Re: Conditional Field List. 12-10-2025 09:33 AM
- Posted Re: Attribute Validation / Calculation using Arcade or Database Trigger on Geodatabase Questions. 12-09-2025 04:26 PM
- Posted Re: Attribute Validation / Calculation using Arcade or Database Trigger on Geodatabase Questions. 12-08-2025 11:45 PM
- Posted Re: Database Triggers vs. Calculation Attribute Rules on Attribute Rules Questions. 12-05-2025 01:22 AM
- Posted Re: Attribute Validation / Calculation using Arcade or Database Trigger on Geodatabase Questions. 12-05-2025 01:02 AM
- Posted Re: Attribute Validation / Calculation using Arcade or Database Trigger on Geodatabase Questions. 12-03-2025 11:38 PM
- Posted Attribute Validation / Calculation using Arcade or Database Trigger on Geodatabase Questions. 12-03-2025 12:57 AM
- Posted the mechanism of arcade Attribute Validation on ArcGIS Enterprise Questions. 12-01-2025 09:59 PM
- Posted Re: Postgresql trigger to maintain coloumn uniqueness on ArcGIS Field Maps Questions. 12-01-2025 04:48 PM
- Posted Postgresql trigger to maintain coloumn uniqueness on ArcGIS Field Maps Questions. 11-30-2025 11:24 PM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
02-04-2026
05:39 PM
|