Tag Info

New answers tagged

1

Close ArcGIS and ArcCatalog. In Oracle 11g, the sequence of your non-spatial table, if registered with the Geodatabase, will be created by SDE under a name similar to this one: 'R5834' If you go to the tab 'Other Users' in SQL Developer, go to the user SDE and then open the table TABLE_REGISTRY, you should be able to see the table registered with the ...


2

Following functions exist in Oracle: SDO_CS.MAP_EPSG_SRID_TO_ORACLE SDO_CS.MAP_ORACLE_SRID_TO_EPSG So SELECT SDO_CS.MAP_ORACLE_SRID_TO_EPSG(xxx) FROM dual; yields: 90112 -> null 327680 -> 31300 8307 -> 4326 (Weird that 90112 isn't mapped...)


0

I eventually found the cause (and solution) to this problem, and wanted to share them in case someone ran into a similar situation. In my sql snippet included in my original post, you can see that I am attempting to filter out null geometries (N.SHAPE IS NOT NULL). Eventually I found that the table had geometries that were not truly null, but had no ...


0

Save the syntax below to a file with a .sql extension (ie: C:\TEMP\get_table_privs.sql). Then log into SQL*Plus as the owner of the table you want to see the privileges for and execute the script. Hope this helps. -ST ------------------------- -- GET_TABLE_PRIVS.SQL -- ------------------------- select table_name from sde.layers where owner = USER union ...


2

It looks like EZConnect can't connect for whatever reason (3a works/3b doesn't). You can try adding "ezconnect" to NAMES.DIRECTORY_PATH in the sqlnet.ora file. Hopefully that will make 3b from @Albert Godfrind's answer work. The LDAP connection may fail from QGIS because you have something like the Oracle Instant Client somewhere in the path before your ...



Top 50 recent answers are included