Creating and configuring the Reviewer workspace in a geodatabase in Oracle

Available with Data Reviewer license.

The server administrator needs to create a new geodatabase in Oracle that can be used as the Reviewer workspace.

Learn more about creating a geodatabase in Oracle

Recommendations for a geodatabase in Oracle

It is recommended that the following parameter values be used when creating a geodatabase in Oracle.

Oracle parameters

Parameter name	Value
Configure with Database Enterprise Manager	Enabled
Automatic Memory Management	Enabled
Database Components	Oracle Text
OPEN_CURSORS	10000
SESSION_CACHED_CURSORS	50–150
DEFERRED_SEGMENT_CREATION	False
RESOURCE_LIMIT	True
ALTER PROFILE "DEFAULT" LIMIT IDLE_TIME 60 Note: When working with very large datasets, you may need to increase the IDLE_TIME to "UNLIMITED". PASSWORD_LIFE_TIME UNLIMITED PASSWORD_GRACE_TIME UNLIMITED	Set Default profile for data owner users
RECYCLEBIN	Off