Searching the Oracle Topology
Searching Oracle Topology Instructions
If you have access to an Oracle server, try the following:
- Display database links: Go to SQL*Plus and enter
select * from all_db_links;
to see all links you are allowed to use.
- 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
|Owner (DBA_DB_LINKS and ALL_DB_LINKS only)||The owner of the database 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.|