Tag Info

Hot answers tagged

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 ...


2

Situations requiring edit sessions: Feature classes participating in a topology Feature classes participating in a geometric network Versioned datasets in ArcSDE geodatabases Some object and feature classes with class extensions I'd say you need to start an edit session, and save the edits before you do the append. The Editor class allows use of ...


2

You may use ListWorkspaces method (once you make the connection) to list the existing databases within SDE: Lists all of the workspaces within the set workspace. Search conditions can be specified for the workspace name and workspace type to limit the list that is returned. workspaces = arcpy.ListWorkspaces("*", "SDE") for workspace in ...


2

Yes, you will need to use the external procedure agent if you want to access the XML columns in the SDE.GDB_ITEMS_VW views. By default, the XML columns in the GDB_* tables are stored using ESRI's XML implementation. The functionality to convert these to a CLOB is included in the ST_Geometry library, which is accessed using the external procedure agent. ...


2

I think your proposed solution may be too complicated. I don't think there really is any such thing as a "non-spatial database". In my view, there's just data, some of which happens to have geometry, and some of which doesn't happen to have direct relationship to geometry (in the end, most data is at least somewhat spatial). Best practice for integration ...


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 ...


1

The answer which I found yesterday, and PolyGeo referenced in his comment above, was to use the full path to the sde instead of the relative path. I still don't understand why the IDLE GUI/shell can't use the relative path when the ArcMap python window can.


1

You will need the sys password of that Oracle instance in order to run the create enterprise geodatabase. If you have another user with dba privileges you can run this to change the password: alter user sys identified by NEWPASSWORD; If you have a database administrator in your organization, they should have the sys password. Optionally, if you have an ...


1

I don't think you can enable attachments more than once per feature class. The easiest way would be to have different feature classes for which attachments you want visible through the feature service.


1

ArcGIS is very sensitive to database names. You cannot restore data unless the database name is identical. You will need to use Feature Class to Feature Class or a copy/paste, or any of the other ways to copy data with Desktop or ArcPy (the list of options can be daunting). All transfers should be done as the data owner(s), not as the administrative 'sde' ...



Only top voted, non community-wiki answers of a minimum length are eligible