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
I usually do not touch this value. If it identified it correctly when registering then I would contact support and have them look into it.
It appears you may be able to update this: Output XY Domain (Environment setting)—Help | Documentation *Note - this may have unintended consequences.
Again, I would focus on why it added the values when registered. Was the SDO_Geometry information incorrect?
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.
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.
'(' || l.minx || ',' || l.miny || ',' || l.maxx || ',' || l.maxy || ')' as data_extent,
'(' || s.falsex || ',' || s.falsey || ',' || s.xyunits || ')' as false_origin
from sde.layers l
inner join sde.spatial_references s
using ( srid );
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.