New answers tagged

0

The function that converts arc into straight segments is SDO_GEOM.SDO_ARC_DENSIFY. Documentation for Oracle 12c is at http://docs.oracle.com/database/121/SPATL/GUID-97E8BF76-34B8-48CA-94A4-96F16B01B60C.htm#SPATL1108 There are two formats for the function SDO_GEOM.SDO_ARC_DENSIFY( geom IN SDO_GEOMETRY, dim IN SDO_DIM_ARRAY ...


0

I was able to use the '-nlt linestring' to export a line feature class successfully. The error appears to have been embedded in the sql statement. I was joining two tables and a view. The view was originally written using the 'myview.*'. I changed the SQL so that added each variable individually. This seemed to work. table1.var1, table2.var2, ...


0

Try this Oracle environment variable: NLS_LANG=AMERICAN_AMERICA.UTF8


0

The fact that tnsping completes is no indication that the database is actually accessible. All it does is tell that the TNS listener is up and running and listening on the port you expect. To illustrate that, just try something like this: tnsping XXX.XXX.XX4.95:1521/whatever and you will still get a successful result. A better way is to test using ...


0

Can you show the SQL definition of the view? Generally only simple views are updatable in Oracle (and other RDBMSs): views that select columns and rows in a single table. Anything else: aggregates, joins, subqueries ... are not. You can make them updatable by adding an INSTEAD OF trigger to the view where you write the logic to apply to properly update ...



Top 50 recent answers are included