Data Management Blog

Unlock the full potential of your spatial data with our essential guide on managing the Enterprise Geodatabase in Oracle's Container Database (CDB) and Pluggable Database (PDB) environments. Discover best practices and key recommendations to optimize performance, ensure security, and streamline workflows. Whether you're a seasoned Oracle database administrator or a newcomer, this article equips you with the insights needed to navigate Oracle's geodatabase landscape effectively.

Which are the release plans for Oracle 23ai (23c) Support for ArcGIS Enterprise?

• Oracle has not released Oracle 23ai On-Premises for Linux and Windows yet. 
• On Nov/01/2024 Oracle has postponed again the release, this time to 2025.
• Esri will certify and support Oracle 23ai with ArcGIS Pro and ArcGIS Enterprise in a future ArcGIS release after Oracle releases the Oracle 23ai On-Premises for Windows and Linux.

You do not have to keep your geodatabase and ArcGIS clients at the same release, but it is recommended that you do so. 

The Rebuild Network Topology tool was introduced with ArcGIS Pro 3.3 for utility network users and was also exposed as the Rebuild current extent option on the Validate dropdown. This tool and command provide the ability to rebuild the network topology in the current extent of an active map.  This Add-In enables users who remain on ArcGIS Pro 2.9 and 3.1 to benefit from this functionality.

Workflows have been identified that can cause inconsistencies in the branch versioning system tables. When such an issue is encountered, features with missing branch versioning metadata can cause data inconsistencies when the version is reconciled, posted, and/or deleted.

ArcSDE User-Schema Geodatabases in Oracle are deprecated

When creating and updating features using Forms in the Editor widget, calculated expressions can be triggered to populate field values automatically.

The challenge: values for fields with calculated expressions cannot be edited or recalculated on demand, while editable fields do not support calculated expressions.

A workaround is proposed in this article.

Intended for database administrators as recommendations for establishing the product workspaces in an Enterprise Geodatabase (Oracle®, SQL Server®, PostgreSQL®).

Mapping & Charting Solutions (MCS) Enterprise Databases Best Practices

Intended for database administrators as recommendations for establishing the product workspaces in an Enterprise Geodatabase (Oracle®, SQL Server®, PostgreSQL®).

Automate data ingest using your SQL skills!