Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [oracle-12c]

The tag has no usage guidance.

0
votes
0answers
36 views

One or more objects failed to paste. Underlying DBMS ORA-00932 : inconsistent datatype

I am migrating all data from a geodatabse oracle to a new oracle schema. I'm trying to copy / paste between the two db connections, but it stops in the middle of the operation by displaying the ...
2
votes
0answers
52 views

Select events that represent the most recent work on roads

I have a question on Stack Overflow where I ask about Selecting events that represent the most recent work on roads. So far, I have been provided an answer that seems to work, although it is quite ...
0
votes
1answer
24 views

Releasing user-schema locks when updating user-schema

Putting together a scripted event where we update user-schema (prod) in one sde instance from a dev user-schema instance. Both sdes are Oracle 12c. Replication is not used and the destination ...
1
vote
2answers
672 views

Oracle SDO_UTIL.GETVERTICES returns more than 1 vertex

I'm using Oracle 12.1.0.2.0 and I am getting extrange results using sdo_util.getvertices. This query returns 2 "vertex" instead of one (as expected) SELECT T.x, T.y FROM TABLE( SDO_UTIL....
1
vote
0answers
28 views

How do I make this subquery factoring work with st_geometry predicates?

I have the following SQL: WITH w AS (select shape from schema.feature_class_polygon fcp where fcp.field = 123456) SELECT count(*) FROM schema.feature_class_lines fcl WHERE sde.st_intersects(w.shape,...
1
vote
0answers
109 views

Make Query Layer - field not available as unique identifier when using NVL [duplicate]

I need to create a spatial view with Make Query Layer. My query includes outer joins, so I must combine every table's ID field to create a unique identifier. Since there might not always be a child ...
3
votes
1answer
1k views

Line to polygon in Oracle Spatial

I have a table that contains buildings in a line geometry where a line starts and ends at the same point. Is there away to convert lines to polygons in Oracle Spatial?
7
votes
4answers
776 views

Does the OBJECTID in an Oracle Geodatabase table have a primary key constraint, by default?

Tables that are created in Oracle using ArcGIS Desktop are given an OBJECTID field by default. The OBJECTID field is assigned a unique not-nullable index. Does the OBJECTID in an Oracle Geodatabase ...
4
votes
2answers
864 views

Connecting to Oracle User Schema Geodatabase using ArcObjects?

I've set up an Oracle user Schema geodatabase and loaded some data into it. I now want to connect to it programmatically using ArcObjects, the problem is I don't see how. Where can I set the newly ...