How to edit domain, resolution and Tolerance

Question

I have some wrong values created when I used 'register with geodatabase' option for feature class with Oracle spatial.

Due to the wrong values in there, I am not able insert data into the feature class. Could you suggest how to edit/ import values from another feature class

Below is the screenshot

Values that I need are below

Kyle_LocGov · Answer

Hello,

Is it possible to alter the z domain in a feature dataset or feature class with geoprocessing tools? The Z range in my features starts at 0 but I need it to include down to -100.

umasuryasykam1 · Answer

Below query helped me to find the issue and resolve. Someone posted the query in another question in geonet. I can mark that as answer if I find it.

select l.table_name,
       l.spatial_column,
       '(' || l.minx || ',' || l.miny || ',' || l.maxx || ',' || l.maxy || ')' as data_extent,
       srid,auth_srid,
       '(' || s.falsex || ',' || s.falsey || ',' || s.xyunits || ')' as false_origin
  from sde.layers l
       inner join sde.spatial_references s 
       using ( srid );

Regards,

Umasurya

umasuryasykam1 · Answer

Hi, Thank you. In the source database everything is fine. I needed to created another database instances. In that process I exported all the schemas. Created SDE user in new database and converted that as enterprize geodatabase using arccatalog. Ran the backup scripts to create users and schemas and registered each table into geodatabase.

Everything seemed fine except above values being wrong. Could you tell which table in oracle I need to update or reference. e.g. SDO_USER_GEOM_data or spatial_references etc.

Appreciate your help.

Regards,

Umasurya