Latest Contributions by yockee

‎10-31-2022

Hi @MarceloMarques I try to move the spatial index into new tablespace (the same with the feature class's tablespace). Here is what I do : - DROP INDEX SDE.A276_IX1 FORCE; -- I have to drop it otherwise it can not be rebuild - CREATE INDEX SDE.A276_IX1 ON FEATURECLASS_LN_1K(SHAPE) INDEXTYPE IS sde.st_spatial_index PARAMETERS('st_grids=840 st_srid=32748 ST_COMMIT_ROWS = 10000 PCTFREE 0 INITRANS 4 TABLESPACE USERDATA1'); --recreating the index because ALTER index REBUILD does not work But when I check using query : "SELECT * FROM dba_indexes WHERE rownum < 5 AND table_name = 'FEATURECLASS_LN_1K'", the TABLESPACE_NAME = NULL and STATUS = VALID. How can I create spatial index via query correctly ? Why is the tablespace_name is NULL ?

‎10-19-2022

Additional question. 1. Actually, a Feature Class has 3 indexes associated with it : Lob (SYS_IL*), Normal (R*_SDE_ROWID) and Spatial (A*_IX1). For the Lob index, do I need to move it as well ? There is no indication that the Lob Index is unusable. How can I move the Lob Index anyway ? when I run this query "ALTER INDEX SYS_IL0000196018C00023$$ REBUILD TABLESPACE DATAUSER1" There is error : "SQL Error [2243] [42000]: ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option" 2. This command fails for moving spatial index : ALTER INDEX SDE.A280_IX1 REBUILD PARALLEL 8 NOLOGGING TABLESPACE DATAUSER1; Any other alternative command ?

‎10-03-2022

@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

‎09-26-2022

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

‎09-26-2022

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

‎09-25-2022

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

‎08-29-2022

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 ?

‎08-29-2022

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.

‎08-28-2022

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

‎07-24-2022

@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 ?

‎07-02-2022

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

‎06-29-2022

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

‎06-29-2022

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

‎06-28-2022

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.

‎06-27-2022

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

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by yockee

Re: Rebuild Indexes after moving tablespace

Re: Rebuild Indexes after moving tablespace

Re: Rebuild Indexes after moving tablespace

Re: Rebuild Indexes after moving tablespace

Rebuild Indexes after moving tablespace

Re: Separating SDE system tables from user tables

Re: Is it absolutely necessary to separate user data from system tables

Beyond moving user data into another tablesapace

Is it absolutely necessary to separate user data from system tables

Re: Separating SDE system tables from user tables

Re: How to repoint all map services to a new data source ?

Re: How to repoint all map services to a new data source ?

Re: How to repoint all map services to a new data source ?

How to repoint all map services to a new data source ?

Re: CREATE DATABASE USER TOOL and tablespace best pratice

Re: Conditional Field List

Editing WFS-T via QGIS

Re: Finding distance between paired points

can not create Feature Class due to connection los...

Re: Feature Dataset performance