<< Click to Display Table of Contents >>

Overview Tables and Views

Top Previous Next

Overview Tables is the default sheet that is displayed when you click on the Tables icon in the navigation window. It shows you a list of all the tables and views in the current schema. The icon in front of each object name indicates the type of object. Use the tab register below the grid to select which type of object to view.  Invalid objects are displayed in gray.

 

frmTables_Overview

 

To improve performance, the display of the relevant synonyms can be turned off by clearing the Show Synonyms check box in the upper right corner of the window.  Hora saves the option that you choose and remembers it the next time that you use the same database connection.

      IncludeSynonyms

If you have selected the Views tab and the check box is selected, both views and synonyms of views in the current schema will be displayed. Synonyms can be distinguished from views by their icon. This applies to the All and Tables tabs, as well.

 

Synonyms of views or tables that are outside the current database are not displayed on this page for performance reasons. To see these synonyms, click the Synonyms icon in the Sidebar.

 

The list contains the following columns

Name of the table, view or synonym

Comments on the object

Timestamp for the creation of the object

Timestamp for the last DDL change (including GRANT and REVOKE) to the object

Timestamp for the last table analyze

Flags

Statistics

Storage parameters

Buffer pools

Freelists

Space usage

Transactions

Parallelism

Data pertaining to index-organized tables

Data pertaining to object tables

The following context operations are available from the Overview Tables and Views grid. Some of them can also be found on the Toolbar :

 

Create

TablesCreateTable

Table

Shows a modal dialog for creating a new table

 

 

TablesCreateView

View

Creates a new view

 

 

 

TablesCreateSynonym

 

Synonym

 

Creates a synonym for a local table

 

 

 

Snapshot Log

 

Creates a snapshot log for the selected table

 

 

 

Table from Import Source...

Opens the Data Import Wizard

DROP

Drop

 

 

Drops the selected table(s).

 

Truncate

 

 

Truncates table, i.e. deletes the entire table contents using the TRUNCATE statement.

 

Delete

 

 

Deletes all rows of the table using the DELETE statement.

Tablespace

Move tablespace

 

 

 

Shows a modal dialog for moving the table to another tablespace

Compile

Compile

 

 

Recompiles the selected view.

 

Logging

 

 

Allows logging to be turned on or off.

 

Table Monitoring

 

 

Allows Tabl monitoring to be turned on or off.

 

Index Monitoring

 

 

Allows Index monitoring to be turned on or off.

 

Allocate Extent

 

 

 

Allocates a new extent for the table.

 

Copy to clipboard

CopySQL

SELECT statement

Creates a formatted SQL statement "SELECT col1, ..., coln FROM table" and copies it into the Windows clipboard.

 

 

 

CURSOR FOR LOOP

 

 

 

 

Table structure description

Copies the displayed information in plain text to your clipboard.

 

Table Statistics

 

Gather table statistics

Executes DBMS_STATS. gather_table_stats against the table, and optionally, through the Cascade check box, against its associated indexes.

 

 

 

Delete table statistics

Executes DBMS_STATS. delete_table_stats against the table.

 

 

 

Lock table statistics

 

 

 

 

Unlock table statistics

 

 

 

 

Restore table statistics

 

 

 

 

Validate Structure

Analyzes the table and validates its structure.

 

 

 

List chained rows

Analyzes the table and lists chained rows.

 

 

 

Analyze (deprecated)

Allows computing, estimating and deleting of table statistics.

TablesEstimateSpace

Estimate Space

 

 

Estimates disk space required for the table.

PROPERTIES

Properties/Alter/Rename

 

 

Shows a modal dialog for viewing and modifying table properties, storage parameters, and table comments and for renaming the table, or for changing the definition or comments of a view or a synonym.

ShowDDL

Show DDL

 

 

Shows the DDL statements to create the table including comments, constraints, indexes and triggers.

datacontentsbrowser

Data Contents Browser

 

 

Adds the selected table or view to the Data Browser, and makes the Browser visible.

 

Search

 

Column Names/comments

Searches for the specified string within all column names/comments of the objects in the overview

 

 

 

Constraint names

Searches for the specified string within all constraint names of the objects in the overview

 

 

 

Index names

Searches for the specified string within all index names of the objects in the overview

 

 

 

Trigger names

Searches for the specified string within all trigger names of the objects in the overview

 

Grid View

 

 

For more information, see object window