3
votes
2answers
58 views

Failed to connect to the specified server, ArcGIS 10.1 connection using Oracle 11 g

I am trying to connect an Oracle 11g database to ArcGIS 10, but it's not working and gives the following error: "Failed to connect to the specified server. Operation Failed." While I am sure about ...
4
votes
2answers
184 views

Is there a SDE command to export/import feature class schema only without data?

I'm using ArcGIS Server 10.0, ArcSDE 10.0 and Oracle 11g. I'd like to create a sde export of my layers' schema. The export would be used to create easily those layer in a new database instance. Do ...
2
votes
1answer
64 views

How to register table with geodatabase with a command line?

Is there a way to register with geodatabase a table stored in an Oracle 11g database, without using ArcMap or Python script? I'd like to do it with a command line like when registering with ArcSDE ...
8
votes
1answer
594 views

How to trace SQL queries sent by ArcGIS Server (ArcSDE) to Oracle database?

I'd like to generate a log file containing all SQL queries sent by ArcGIS Server (ArcSDE) to Oracle database. Is there a way to do so? I'm using Oracle 11g and ArcGIS Server 10.0 on Windows. ArcSDE is ...
2
votes
2answers
601 views

Is ArcMap 10.0 Query Layer passing invalid SQL to Oracle 11gR2?

In two different environments I'm having trouble using ArcMap 10.0 Query Layers to view SDO_GEOMETRY (point) data in Oracle 11.2. This suggests I'm doing something wrong... Points are in Oracle ...