Try OpenEdge Now
skip to main content
Online Help
Introducing Progress DB Navigator : Reference : Oracle database : Oracle DB Structure View
 
Oracle DB Structure View
When you open a connection in the Connections view, the schema for the database appears in the DB Structure view. The DB Structure view is a tree view that shows a separate structure for each schema under the root node Database.
Note: You can configure DB Navigator to display or hide schemas. By default, catalogs are displayed while schemas are hidden from view. See DB Navigator preferences for more information.
When you select certain nodes in the DB Structure view, properties and values appear in the DB Details view.
The top-level nodes in the Oracle DB Structure view are Database, Monitor, Security, and Instance. You can use filters to show only certain schema items in the view; you cannot, however, create or edit schema.
Database
The root node Database is at the top level of the DB Structure view. If the database supports catalogs and you have selected Show catalog in the DB Navigator preferences, all catalogs appear below the database node. If you have selected Show schema in the DB Navigator preferences, all schemas appear below the database node.
Beneath the schema and catalog nodes, the following child nodes appear:
SYNONYM
All aliases that were created in SQL against tables. SQL statements can use these aliases instead of the name specified when the schema item, such as table, view, or synonym, for example, was created. The child nodes contain only tables, views, or other synonyms. They do not display columns or indexes of the tables.
TABLE
Displays all application tables. Table nodes expand to show columns and indexes. When you select a table name, data and meta-data appear in the DB Details view.
Note: Since tables are displayed in ASCII order and sorting is case-sensitive, all lowercase table names sort after the uppercase table names.
VIEW
Displays the names of all created views. A SQL view allows you to extract rows and columns from one or more related tables and to treat the resulting data set as a virtual table that can be viewed or updated.
SEQUENCE
Displays all sequences, which create an incremented, serial list of numbers applied to a column in a database table.
PACKAGE
Displays all packages, which contain specific procedures, functions, and other schema items in one entity.
PACKAGE BODY
Displays details about each package body, including the SQL code, and properties and their values.
FUNCTION
Displays all functions, or pieces of a program that you can use separately from the remainder of the program.
PROCEDURE
Displays all procedures that are stored in the database and available for reuse.
TRIGGER
Displays all triggers, which you define to run when you modify a table or view or when a particular action occurs.
SESSIONS
Displays information about the current user-to-database connection in the DB Details view.
JAVA SOURCE
Displays all Java objects.
DATABASE LINK
Displays all database links. Each database link is present as a local database object and contains specifics necessary for connecting to another database.
Monitor
When you select the Monitor node, the following subnodes appear:
SESSIONS
Displays information about the current session, such as username, Session ID, machine name, and the user's logon time, in the DB Details view.
JOBS
Displays information about a job, or task, that you run once or on a particular schedule, in the DB Details view.
TOP SQL
Displays SQL executions in the DB Details view, enabling you to see how resources are affected when a SQL statement is executing.
Security
When you select the Security node, the following subnode appears:
Users
Displays all authenticated users by username, user ID, and the date on which the user was created.
Instance
When you select the Instance node, the following subnodes appear:
System Parameters
Displays all system parameters (retrieved from the v$system_parameter table) in a viewer.
TableSpace
Displays all table spaces, or logical storage units, in the database.