English

FAQ: What objects can I load into ArcView when I connect to an Oracle database?

Question

What objects can I load into ArcView when I connect to an Oracle database?

Answer

The answer depends upon how you connect to Oracle. ArcView provides two interfaces for connecting to a database: SQL Connect and Database Access. In addition, each interface allows for different connect methods. The objects made available for loading depend upon the interface and connect method. Here are the types of objects you will see depending on how you connect to Oracle.

SQLConnect:

Oracle ODBC Driver:
All the objects you own or have been granted select privileges to. This includes all tables, views, and synonyms. However, it does not include those objects to which PUBLIC has been granted select privileges.

Microsoft ODBC driver for Oracle:
Same as for the Oracle ODBC driver, except you will also see all the objects to which PUBLIC has been granted select privileges.
Database Access:

ODBC Connection:
All the objects you own or have been granted select privileges to, including all tables, views, and synonyms. This also includes the objects to which PUBLIC has been granted select privileges. If ArcSDE is installed on the server, you will also see the Business, Feature, Spatial Index, and Delta tables for each layer you own or have been granted select privileges to, in addition to the ArcSDE metadata tables.

SDE Connection:
All the tables which you own or have been granted select privileges to. This includes tables to which PUBLIC has been granted select privileges. If ArcSDE is installed on the server, then you will also see the business tables for each layer you own or have been granted select privileges to, but not the Delta, Feature, or Spatial Index tables.