RelationalDBDesign 





Network Topology   «Prev 
Application connection with SQL*Net

Searching the Oracle Topology

Searching Oracle Topology Instructions
If you have access to an Oracle server, try the following:
  1. Display database links: Go to SQL*Plus and enter select * from all_db_links; to see all links you are allowed to use.
  2. Find your tnsnames.ora file. On UNIX, look in $ORACLE_HOME/network/admin. On a PC, try c:\orant\network\admin.
The results of your search will vary and are particular to the server to which you connected and its topology.

A collection layer is a topology geometry layer that can contain topological elements of different topology geometry types. For example, using the sample CITY_DATA topology, you could create a collection layer to contain specific land parcel, city street, and traffic sign elements.

Features Built from Topological Elements in Parent Layers

In a topology with a topology geometry layer hierarchy, within each level above level 0, each layer can now contain features built from topological elements (faces, nodes, edges) in addition to (or instead of) features built from features at the next lower level. For example, a tracts layer can contain tracts built from block groups or tracts built from faces, or both.


DBA_DB_LINKS, ALL_DB_LINKS, and USER_DB_LINKS Field Descriptions


Field Name Description
Owner (DBA_DB_LINKS and ALL_DB_LINKS only) The owner of the database link.
DB_LINK The name of the database link. This is the remote database name and the domain name.
Username The username specified in the CONNECT TO clause. NULL if the CONNECT TO clause is not supplied.
Password (USER_DB_LINKS only) The password specified in the CONNECT TO clause. NULL if the CONNECT TO clause is not supplied.
Host The SQL*Net connect string to the remote database. This corresponds to the USING clause. NULL if the USING clause is not supplied.
Created Date the database link was created.