Is This Content Helpful?
We're glad to know this article was helpful.
Sometimes it is necessary to access data from remote database instances. A view may be created locally using data from a remote table or view.
Instructions provided describe a sample scenario that explains how to create a local view using the sde command line interface with a view created on a remote database instance.
In this scenario, local Machine A has ArcSDE and an Oracle instance, and a view is created using data located on a remote offsite Oracle instance (Machine B).
• Local Server (Machine A)= 'charlotte' running ArcSDE 9.3.1, schema = GISADMIN and Oracle10g
• Remote Server (Machine B)= 'winston' with Oracle 10g, schema = REMOTE
create view CITY_VIEW as select NAME from CITIES;
The remainder of the steps are performed on the local machine, Machine A ('charlotte').
This may already be configured.
grant create database link to GISADMIN;
create database link dblinkdemo connect to REMOTE identified by remote using 'winston_rem';
Sample syntax: [CREATE DATABASE LINK other_db CONNECT TO <schema> IDENTIFIED BY <password>
Sample syntax: schema.view_name@linkname
sdetable -o create_view -T LOCAL_VIEW -t REMOTE.CITY_VIEW@dblinkdemo -c REMOTE.CITY_VIEW.CITY_NAME -i esri_prod -s charlotte -u GISADMIN -p GISADMIN