<< 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.




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.


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



Storage parameters

Buffer pools


Space usage



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 :





Shows a modal dialog for creating a new table





Creates a new view








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





Drops the selected table(s).





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





Deletes all rows of the table using the DELETE statement.


Move tablespace




Shows a modal dialog for moving the table to another tablespace





Recompiles the selected view.





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


SELECT statement

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









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.


Estimate Space



Estimates disk space required for the table.





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.


Show DDL



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


Data Contents Browser



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




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