Current Version: 10.1.1.0
- The new AWR button on the database page gives you an interface to Oracle’s Automatic Workload Repository.
Please be aware of the fact that only users that licensed Oracle Enterprise Manager Diagnostic Pack are entitled to use AWR.
The first tab lists AWR snapshots grouped by database instance. The context menu allows you to add a new snapshot manually or create and show an AWR report.
- The create insert script command now temporarily disables self-referencing foreign keys.
- Rev/DDL's compile schema option is now checked by default and adds code to recompile invalid views.
- The file search dialog on the SQL page is now available on SQL scratchpad as seen on file explorer.
- The tree view on data contents now implements foreign key lookup same way as the grid view.
- Improved formatting of Low Value and High Value on both Tables|columns and Tables|Statistics grids.
- The data grid build-in filters now work case insensitive. A new checkbox on the “Behavior” settings page allows you to get back to case sensitive filtering.
- Rev/DDL has got two new main menu items to save and restore a configuration to an XML file.
- The filter tab-set below the Tables | Overview grid changed from “All |Tables | Views” to “Tables | Views | Tables and Views”, i.e. “All” became “Tables and Views” because the small “All” tab could be overlooked easily.
- Both the “open table” button on the data contents browser and the “open other table” tab on the data contents detail view show the “Open table” dialog. It allows you to select a table name from a combo box and enter an optional filter condition. The filter combo box now shows a couple of filter templates. They are based on columns of the selected table such as COLUMN_NAME = '?' and can be changed. If you are on the data contents details view, references to the master table such as DETAIL_COLUMN = :MASTER_ID are added as well. allows you to display your data in a master-detail relationship, even if there is no foreign key reference.
- A new checkbox option allows you to change between multi-column and single-column record view layout.
- The new menu item "Schema | Search all tables in schema for string ..." allows you to search the entire database schema for a string sample.The dialog shows table names, column names and the number of matches.
- The MS-Excel export button now creates XLSX file format without the limitation of 65536 lines related to XLS file format.
- The Explain Plan context menu item auto-selects the SQL statement at cursor position similar to the Execute SQL command (Ctrl+E)
- The Scheduler page has been enabled for users with standard privileges
- Schema page uses DBA-Views instead of ALL-Views when accessible.
- The Show DDL menu item is now enabled for multi-selection on the Tables, PL/SQL and Sequences page.
- An asterisk shows up in the Statusbar to indicate the editor contains unsaved text.
- The Tablespace fragmentation tab is now a detail view below the datafiles grid view and replaces the former free space subview. It gives you a better overview of used and free space.
- Significant less memory consumption when creating an Insert or Update script from data contents view.
- The generated Insert or Update script now contains an ALTER SESSION SET CURSOR_SHARING=FORCE statement for faster execution of big scripts.
- The Index | Index Statistics - Validate Structure context menu item now shows results from INDEX_HISTOGRAM as diagram view and INDEX_STATS as data view.
- Dialogs for gathering system, database, schema, table and index statistics show more options matching dbms_stats procedure parameters.
- Added new context menu items to lock, unlock and restore schema and table statistics.
- A new tab sheet on the database page shows dbms_stats system statistics. The context menu allows you to update statistics by calling dbms_stats.gather_system_stats.
- Added a new column group to the tables | columns view. It uses optimizer statistics to show how frequently the column has been used in different WHERE predicates and a timestamp of last usage in a WHERE predicate. You can use the information to decide wether indexing the column would make sense. You need either HORA_USER or SELECT ANY DICTIONARY role or SELECT privileges ON sys.col_usage$, sys.col$, sys.obj$ and sys.user$. If you are lacking privileges, the appropriate columns keep null.
- Tables | columns view now shows also the filter row known from the overview grids.
- Support for compound triggers.
- New tables | statistics view shows information about table and column statistics, histograms, statistic history and preferences.
- On Windows 7 Hora 10 provides a Jumplist for the Windows Taskbar showing the most recent connections.
- New wrapped columnar layout for record view.
- The record view is now printable.
- Both grid and record view can show a popup calculator for non-indexed numeric columns.
- Both grid and record view now implement active tooltip hints that provide context sensitive lookup information from the database and the dictionary:
- For the indicator column in the very left of the data content and SQL result set grids you will be shown a comma separated list of row values that is called instant record view. There is a setting that toggles prefixing each value with column name.
- For column headers you can see the SQL datatype of the underlying table column, the column comment and information about constraints.
- For data content cell values that reference another table by a foreign key relation you will see a list of lookup values from the referenced master table. There is a setting to switch it all off for slow database connections.
- Added a slider to the chart view to adjust the number of categories (i.e. x-axis values) shown per page.
- Offline datafiles are displayed grayed, those needing recovery use red font.
- SQL Scratchpad remembers last used tree node for each connection.
- The SQL editor now sports a check list box showing an item for each SQL file in the current folder. You can batch execute a selected subset of files and it will consecutively load a file in the editor and execute it.
- The new Pivot view on both data contents and sql query result set view is very powerful. You can drag-drop one or more fields to the filter, column, row and data sections of the cross table grid. After that, the pivot view shows data including column and row totals. A chart view below shows the same data. You can select a smaller region of cells to reduce the amount of data show in the chart.
- DDL creation for profiles.
- Omit datafile name from DLL if db_create_file_dest parameter is set.
- Roles granted to a user are now displayed hierarchically using a tree view. Object and system privileges can be shown in the context of the user or any role from the hierarchy. A checkbox allows you to include privileges granted to subordinate roles as well. Roles granted to roles are displayed on the Database page similarly.
- Explain plan dialog shows costs with decimal separators.
- The Database|Undo (Rollback) segments page shows recommendations for undo tablespace size and undo retention time based on v$undosta.
- Show DDL menu item enabled for multi-selection on Synonyms page. This is especially useful for reverse engineering a bunch of public synonyms.
- The dropdown list of the current schema selection box in the lower left of the main form now shows your login schema, CTXSYS, SYS and PUBLIC using bold text font.
- The database | NLS parameters page shows NLS_LANG client settings from the Windows registry, environment variable and resulting NLS_LANG.
- The Tables | Create table from import source dialog has been redesigned.
- The new menu items File | Write to Oracle | Alert log, Trace File, Both allow administrators to leave a message in the Oracle trace file, alert log file, or both.
- New page Data Pump shows information about Oracle datapump export and import.
- The foreign key lookup dialog of the data contents grid now works in the filter row as well as in data rows. Press Return key to apply selected filter value.
- Using the new File | Open File menu item, the corresponding toolbar button or Ctrl+O you can open an existing SQL file without navigating the file explorer on the SQL page. It will open in the PL/SQL editor similar to the "Open in separate editor" context menu item. Another new menu item File | New File and the corresponding toolbar button open the PL/SQL editor with an empty file.
- The "Describe" context submenu item has been moved from "Query" to a new menu item "Selected Object" right below "Query". There are three additional submenu items that allow you to expand a selected table name to a full SELECT, INSERT or UPDATE statement similar to the copy to clipboard commands on the Tables page. Another new submenu item "Show data" opens the result grid window showing the data of the selected table or view.
- New tab sheet „Feature Usage“ on database page shows statistics about usage of Oracle features.
- The Clear Schema procedure now drops jobs and triggers prior to other database objects.
- Added a checkbox above the DBA|Users|Roles grid that includes object privileges implicitly granted by role. They are marked '~' to distinguish them from privileges granted to the user (lower case 'x') directly and those besides grantable (upper case 'X').
- On the Sessions | Locks page is a new checkbox "is user" that indicates wether the lock type takes part in the mechanism of locking sessions against each other. No-user locks are displayed in gray font. In accordance to this change the overview page now counts only user locks held and requested
- Temporary Tablespace | Temp/Sort Segment Usage is shown in detail grid.
- Using XMLSERIALIZE the data contents grid now shows XMLTYPE columns as CLOB in read-only mode. Please remember, you get full read/write support for XMLTYPE columns when connected with an Oracle client.
- The maximum number of dropdown list values for grid column filters is limited in order to save grid performance. This limit now can be customized using the Extras|Settings|Behavior|FilterMaxValueListCount spin edit control. You can change the value to zero for unlimited dropdown list size but this may result in poor grid performance for large result sets.
- The Show DDL command for a selection of multiple users now generates a common block with distinct ROLE and TABLESPACE create statements for the selected users.
- Network licensing compatibility improvements for less privileged OS users
- The tablespace overview grid now shows a checkbox that is checked for the default permanent and temporary tablespace. The context menu allows you to set a tablespace as default.
This requires Oracle 9i for temporary and 10g for permanent default tablespaces.
- The users overview grid has got a new column that shows the number of objects owned by the user. It keeps blank for users without objects. This allows you to filter by not null values to show all database objects owners.
- There is a new button on the Schema | PL/SQL errors page that allows you to edit the PL/SQL object and show the error. This is similar to the existing "edit in a new window" button on the PL/SQL overview page.
- Minor improvements for handling temporary tables.
- Array fetch size for overview grids is now configurable by settings.
- Performance enhancement on tables page.
- Load/save template button on data export wizard
- A new check box option has been added: Behavior - Disable in-memory mode for tabbed data grids.
It is recommended to check only if there are tens of thousands of tables in one schema. This will speed up data grid performance and disable some enhanced grid options.
The setting does not influence data contents and SQL scratch pad pages since both always come up without in-memory grid mode.
- Office 2010 compatible skins
- New Windows Service Application that keeps network licensing grace period charged on Windows Vista and later.
- Data export and import dialogs replaced.
- Added Granularity and Degree options to the analyze schema, table and index dialoges (dbms_stats interface), especially for partitioned tables.
- Added V$SESSION.SERVER column on sessions page.
- Setup routine with improved Windows 7 support
- The modal dialog for analyzing table using dbms_stats now allows you to enter a estimate percent value. By default it keeps blank as before. Furthermore, if the table is partitioned, you can select a partition from the combo box. If you keep the box empty the entire table will be analyzed as before
A new context menu item for tables | partitions has been added to give access to the dialog from the context of a table partition.
- Added support for creating users identified globally (LDAP/AD/OID). The appropriate column EXTERNAL_NAME is shown on the users page. DDL generation has been changed as well. (10 or higher).
- A couple of minor enhancements of create/alter user dialog
- New commands Schema | Statistics | Gather Data Dictionary Statistics, Delete Data Dictionary Statistics, Gather Fixed Objects Statistics, Delete Fixed Objects Statistics accessible for SYS as SYSDBA covering dbms_stats package calls.
- The connection dialog now shows two OCI DLL settings for global and individual Oracle home selection:
- The default OCI DLL is used whenever no other OCI DLL is defined in the complementary box.
- The complementary OCI DLL overrides the default setting for the current SQL*Net_service.
- Both Create Insert Script and Create Update Script menu actions now allow you to change the file encoding between ASCII, Unicode, etc. in the file save dialog.
- If the file editor detects a non-ASCII character such as a German umlaut it suggests switching to Unicode encoding. You can follow or decline the suggestion. Furthermore, a checkbox allows you to suppress further prompting. You can get back to being prompted by checking the box "Ask for change to Unicode" at Extras|Settings|SQL page.
BTW, you can switch file encoding anytime using the file editor context menu.
- Inplace bar diagrams on explain plan tree view for better overview of costs.
- Multi-select option enabled in data grids. Now you can copy the tab-delimited content of selected data rows (excluding invisible columns) into the clipboard by pressing Ctrl+C. Clipboard content fits nicely into MS Excel spreadsheets.
- A new option Others | Query GV$-Views on Sessions page (Enable RAC support) introduces limited RAC support for Oracle 10g and later. If checked, the sessions page queries GV$-views instead of V$-views. As a result, it shows information from other instances as well.
- Modal context menu dialogs now come with full look and feel support for the Office 11 visual style.
- Both data contents browser and Hora's tables overview remember the last used table name separately from the last used view name. When switching from tables to views and back to tables, you will find the last used table name selected again. When switching to views, you will find the last used view name selected.
- Chart view in data contents view and on SQL page now allows you to show up to 5 instead of 2 series.
- Powerful privileges such as DBA, UNLIMITED TABLESPACE, BECOME USER, RESTRICTED SESSION, %ANY%, %P_FULL_DATABASE are highlighted red in appropriate detail grid views of both Users and Roles page.
- UniCode support (UTF-16)
- New filter row in data contents, SQL query result set, Overview grids and connect dialog grid allows fast filtering.
- New Diagram View page for Data Contents and SQL Result allows you to show different chart views of your data.
- New Tree View page for Data Contents and SQL Result allows you to show hierarchical data as tree view
- Connect dialog remembers OCI.DLL for each server and connection.
- Reverse/DDL allows you to select the schema to being reverse engineered.
- Checkbox on DB object browser (editor component) to change between alphabetic and logical column order. Table or column comment for selected node is shown in a new text box below the tree view
- Users page shows a checkbox column that unveils DBA privilege. Users with DBA privilege are listed in red font, locked user accounts in gray.
- New Oracle 11g related information on Users page:
Default password (such as tiger for scott) according to dba_users_with_defpwd dictionary view Checkbox for SYS_ASM login privilege Password versions shows security rules for database users that have been migrated from 10g to 11g
- New Oracle 10g and 11g related information on Tablespace page:
Checkbox for Default table compression
Undo tablespace retention Checkbox "Big file"
Predicate Evaluation (Host/Storage)
Compress for (by default for what kind of operations)
- For Oracle 11g database the triggers list on the tables page shows a new detail grid with firing order definitions.
- You can now tab-switch between session and system parameters on the Database-Parameters page. The context dialog to change parameters shows valid parameters in a combo box from v$parameter_valid_values as far as it is accessible regarding database version and privileges.
- Support for read only constraints on views added.
- Show DDL command for policies on schema page
- PLSQL type dependency view similar to PLSQL package/procedure dependency sheet
- Error messages from import wizard dialog are dumped to dbms_output window. This allows an unlimited number of errors to be read
- Show DDL and Drop Role context menu operations are now available to a selection of multiple grid rows.
- Tablespaces | Segements page shows pie diagram view of tablespace utilization by user.
- Performance|Disk I/O view now includes tempfiles.
- Connect dialog shows new custom category for grouping by such as server location, project name, etc.
- Schema | Disabled Constraints page renamed to Not Validated Constraints. It shows both disabled and not validated constraints. A new column Enabled allows you to filter either of them.
- New page Schema | Dependencies shows relations with and dependencies from other schemes.
- The HTML documentation generator now makes use of a modal connect dialog.
- Data Contents Browser shows number of rows for tables as of last analyzed date.
- Faster completion in SQL editor
- Tablespace and Datafile dialogs now support Oracle Managed Files
- Increased (and customizable) array fetch size in Data Contents and SQL pages for faster data transfer.
- Enhanced LOB performance
- The DB object cache related columns on the PLSQL overview page are now hidden by default. A check box allows you to show them on demand. This increases the performance of the PLSQL page, especially if the database server runs on its limits.
- SQL editor now supports SET TIMING and SET FEEDBACK SqlPlus commands. You can initialize them in the options dialog.
- Elapsed time or number of rows processed is written in the dbms_output window.
- Data Contents Browser shows number of rows for tables as of last analyzed date.
- New button on dbms_output window that allows you to switch stay-on-top property when window is floating.
- New option Pre-Query Record count allows you to query the count of rows before opening the table. It is displayed in the status bar instead of the number of currently fetched rows.
- Password change dialog now adds REPLACE clause for Oracle 9.2 or later.
- Significant performance enhancement when executing scripts with tens of thousands of lines
- In addition to the existing icon that flags primary key columns in the list of table columns, a new blue icon has been added to mark foreign key columns. The primary key icon changed its color from yellow to orange for better visual appearance
- The constraints manager, i.e. Hora's build-in tool that allows you to enable or disable all constraints of the schema, now handles the ORA-00955 error.
- If the index for a primary key or unique constraint already exists, the enable constraint command is re-executed without USING INDEX clause.
- The Reverse DDL engineer now allows you to generate DDL scripts in batch mode. Therefore, you have to run a command like RevDDL.exe <filename> <connectstring> or RevDDL.exe C:\Temp\Scott.SQL SCOTT/TIGER. Please don't forget to "quote" file names including white space.
- If the program is run with at least 2 parameters, error messages are redirected to a file defined by the first parameter.
- In-place editing of table and column comments can be disabled at Extras|Settings, page "behavior".
- Multi select on Tablespaces page for "Show DDL"
- New Pretty-print option available from the context menu of both the embedded and standalone SQL editor (not in HoraLight)
- Master/Detail tables diagram can now be zoomed using a slider.
- Master/Detail tables diagram now can be copied to clipboard (fully scalable enhanced metafile format)
- Several new skins
- New Role Hierarchy diagram on Schema page
- New context menu for adding and dropping redo log members
- Several improvements on Data Import Dialog
- ER-Diagrammer: New menu item for modifying foreign keys
- Performance improvements on several pages
- Microsoft Windows Vista supported
- Support for Oracle 11g virtual columns. Table columns grid shows two new check boxes: "virtual" and "hidden". Use add/change column dialogs to manage virtual columns.
- Support for Oracle 11g invisible indexes. Grid shows the property, and context menu permits modifications.
- Invisibility (to optimizer) property of indexes is shown in the grid
- FastReport Designer now allows you to dynamically create dynamically new subordinate SQL queries (ODAC dataset integration)
- Parameter dialog on the SQL page now lets you set the data type for each parameter
- New "ping" context menu item for db links
- New "Create | Table from import" item on "Tables | Overview" context menu. Creates column types that match the import source.
- List box showing column names in "Add foreign key" dialog now can be ordered either by name or logically.
- New File Search menu item on SQL page’s embedded Windows Explorer window.
- Tablespace | Fragmentation view has been redesigned. It lists the tablespace’s contiguous chunks of segments and free space in reverse order of the way they are stored in the datafile. This means that you will now see segments that prevent downsizing of the tablespace at the top of the list.
- The filter box that dynamically appears below a filtered grid can now recall the last 5 settings using a MRU list.
- The Explain Plan dialog now auto-commits the EXPLAIN PLAN SQL command that is executed when the dialog is shown. Thus the lock on PLAN_TABLE is released.
- Export from data grid to Excel (data contents and SQL scratchpad) now exports numeric values in numeric format.
- Foreign key columns are still exported in “general” format because of technical limitations. Use the export wizard on the underlying dataset to get around this.
- New Refresh button (shortcut F5) next to Commit/Rollback button refreshes the currently active page
- DDL creation for external tables has been improved
- The Query Builder now indicates the type of join (inner, left/right outer) using a solid/framed circle next to the table column. The join type is initialized according to the NOT NULL properties of the joined columns. You can change the join type using the join’s context menu by right-clicking the line that connects the joined tables.
- Excel export and grid mode for tables with timestamp columns are now supported.
- Editor code auto completion (Ctrl+Space code) performance has been improved.
- Increased width of record view controls with context button on data contents page
- Improved tree view performance in SQL Scratchpad
- Skinned user interface, visual appearance of different database connections
- New ftp explorer on SQL page
- Grant dialog for object privileges re-designed.
- PL/SQL Procedures/Call interface page now shows authorization method for procedures and functions (Oracle 9i or later).
- New Tables | Statistics Preferences tab sheet for Oracle 11g with context menu item for changing values
- Scheduler | Global Attributes can now be changed using context menu (10g or later).
- Explain Plan dialog shows the new 11g optimizer_use_invisible_indexes session parameter and allows changing.
- Support for Oracle 11g read-only tables: Tables overview shows status as check box, Properties dialog allows changing.
Read-only data content shown in gray font
- SGA page shows values of new initialization parameters like sga_target and memory_target.
- SGA page now adds a new Oracle 11g result cache tab showing result cache statistics, result cache objects and result cache-related initialization parameters.
- Basic SQL support for inherited object fields
- Optimized LOB fetching memory usage
- The Query builder now allows you to save/retrieve a query definition to/from an XML file.
- Additional parameters are shown for flashback DB (Redo Log page).
- Support for new 11g connect mode AS SYSASM
- Context menu on Schema Privileges page has been improved. It includes now support for granting and revoking privileges.
- New installation program
- Auto-selection of single statement on SQL execution (Ctrl+E)
- Minor tweaks in network license handling eliminated
- New versions of ODAC, JAM and DevExpress 3rd-party libraries
- Improved handling for users without OS administration privileges
- Manifold SQL generation for triggers on views fixed
- Conversation error in tablespace quota dialog fixed
- Improved display of PL/SQL warnings
- Recycle bin objects excluded from several grid and list views
- Expired password can now be changed in connect dialog
- Sidebar bug button response on first click
- Registration form changed
- Improved performance of the off-site license usage feature
- Improved performance when working with the floating license and a poor network connection
- Improved performance for displaying of tables with a large number of columns in Data Contents, Data Contents Browser, and SQL Scratchpad
- Optimized display on the SGA & Statistics | SQL area tab
- Enhancements to Connect Dialog
- Passwords can be stored in encrypted form
- Connections can be displayed grouped by user or server. Connections can also be sorted in reverse chronological order
- Remarks about connections can be entered and saved using the “Short Description” field
- SQL Page
- The SQL Repository is now known as the 'Scratchpad'
- The File Explorer, which previously allowed navigation among SQL and PL/SQL files only, now displays all files
- Hora’s integrated editor now displays ASCII files with syntax highlighting and code folding for the most common languages (SQL, PL/SQL, Java, C++, Pascal, HTML, XML, etc.)
- Elementary lexers for TXT, LOG, as well as .sk, .ksh, .csh
- A binary file, such as a Word document, can be opened directly from the File Explorer with the related application
- File Explorer returns to the last displayed directory for each connection
- Statement detection on the SQL code window
- New File Explorer navigation buttons on the SQL page
- Files can be dragged and dropped from Windows Explorer to File Explorer
- A Print Preview window appears before files are printed
- Schema page / Invalid Objects tab
- The context menu contains two new entries: “Compile All Invalid” and “Show DDL”
- Multiple selection is available using the Ctrl key
- PL/SQL Objects page (formerly Packages)
- The former Packages page is now known as “PL/SQL Objects”
- Triggers can now be displayed on the PL/SQL page, in addition to the Tables page
- The PL/SQL Objects Overview page now contains an additional group, “PL/SQL Debug”
- Performance improvements to the DB Object Browser
- On the Data Contents page, columns with the NOT NULL attribute are highlighted by underlining the column heading
- The context menu on the User Page now makes available the PASSWORD EXPIRE clause of ALTER USER
- New display of the Tables Overview in Data Contents Browser and Query Builder through use of high-performance grid components
- When SQL Recording is in effect, only successfully executed SQL statements are now saved
- Help is now context-sensitive for each page
- The Execution Plan now provides more information. A number of new columns have been added (including Options, Optimizer, Position, Cost, etc.)
- PL/SQL Debugger
- Source code can now be selected via the menu, providing the Debugger has run for at least one step. After the source code is selected, breakpoints can immediately be set
- Context-sensitive graying of buttons and menus has been improved
- The Debugger now automatically provides the Evaluate/Modify function for variables through a tooltip
- Various bugs corrected
- In ER Diagrammer, the hints for connections between tables have been moved further from the connecting lines to facilitate working with the lines.
- Line breaks and spaces in SQL Editor are ignored when a selected SQL statement is being executed.
- New Import/Export Wizard dialogs that allow saving and loading of user-specific profiles via the Specifications button.
- When printing, paper size defaults to either A4 or Letter depending on regional settings.
- The "Optimizer Mode" combo box under Extras > Settings > Session has been redesigned. The FIRST_ROWS and ALL_ROWS options are no longer available. The field can be edited so that combinations of options are possible.
- A new "PL/SQL Warnings" check box is available under Extras > Settings > Session. This enables PL/SQL warnings to be enabled or disabled for 10g databases. - Hora no longer shows package names in red on the Overview page when only warnings have been generated. They will not be shown in red unless there are actual errors.
- Hora automatically requires a new password when a user's password has expired.
- The Connect dialog has been made larger in size.
- Hora issues a warning when the oci.dll file predates the database.
- If no file has been selected on the SQL Page's File Explorer, the editor becomes read-only and has a gray background.
- Improvements to the "Best Fit Columns" function:
- Double-clicking the border between two columns enables Best Fit for the column to the left. This is also true for groups of columns.
- Best Fit Columns" can be automatically put into effect for a certain number of columns or groups, using a new option in Extras > Settings > Behavior.
- Using the check box in the filter panel below the data grid, you can temporarily disable the filter.
- The Tables and PL/SQL page now offer an "Include Synonyms" check box in the upper right corner. The Synonyms tab has been removed from the Tables page.
- Hidden files (those whose name begins with a period) can optionally be made visible or hidden in SQL Scratchpad's File Explorer. The check box to set this option can be found under Extras > Settings > SQL Page > Hide period-prefixed files.
- The SQL Page now offers the ability to execute a single SQL statement with Ctrl + E when the cursor is placed on it.
- Alphabetic sorting in SQL Scratchpad has been corrected.
- Improved performance when switching between tasks.
- Hora now shows the Oracle version and SID in the main form's title bar
- Jobs can now be shown for the current schema or optionally for all schemas
- User/Roles: A new detail view shows the users and roles that have been granted object privileges for the current user
- Overview Tables: New Errors column in the Flags group. This is always NULL, except for Views. Views with errors are also shown in red
- Several bug fixes
- Improvements to the Sessions page:
- A new group, "Waiting," has been added to the Overview, with columns "Waiting Since" and "Seconds"
- An additional column, "Transaction and Blocking," has been added to the Status group
- Another additional group, "Wait Object and Row," has been added
- Information identifying the client application is displayed on the right, in a non-scrolling section
- Only the session causing a lock will now be shown graphically. A session that holds a lock will only be listed in red when it is blocking another session. A blocked session will no longer be shown in red.
Note: To use this feature, available starting with Version 184.108.40.206, the HORA_USER role must be redefined
- The Scheduler icon has been redesigned in a different color to differentiate it from the Jobs icon
- Grant Object Privileges dialog now recalls last selected privileges
- Improved accessibility to tables in other schemas:
Ctrl+Space enables table search without the need to specify owner in Current Schema
- SQL Query Result Set window does not automatically close when leaving the SQL page
- Corrected problem in Find/Replace in Editor when regular expressions are specified
- New Data Contents Browser context menu item: the Editor opens a modal dialog for CLOB columns
- New Enable/Disable context menu item for the Scheduler
- Maximizing and restoring of the DBMS_Output window now possible after closing the window
- PL/SQL Debugger: context menu allows clearing the DBMS_Output window
- ER Diagrammer, DCB and Query Builder show all owners if user has the SELECT ANY TABLE privilege
- ER Diagrammer now clarifies relationships through tool tips
- Dependent and independent tables are visually differentiated in ER-Diagrammer. Non-identifying relationships are now shown as broken lines.
- Several bug fixes
- The Tables context menu allows monitoring for all indexes to be set on or off
- The Indexes context menu allows monitoring to be set on or off for individual indexes
- Information from V$OBJECT_USAGE is now displayed for indexes
- Improved performance when moving from Overview Tables to the Data Contents Browser
- Enhanced display in SQL Editor's Outline window
- Enhanced appearance of SQL Editor's Code Folding feature
- Improvements to direct Excel export (Excel file now shows grouping by columns, when in effect)
- Improvements in navigation through Database Roles
- Improvements in Data Contents (new Record View, new Text View, enhancements to the column headings in Grid View, display of BLOB fields using Windows applications)
- Several bug fixes
- New and easier-to-use interface in all Version 7 products
- Powerful new data grid component
- Much better performance when managing query results available through the optional in-memory mode on the client
- Grouping, including multiple levels
- Calculation of sum, average, min, max, count
- For details, see our newsletter of january 2006
- New SQL Editor with
- Collapsible code
- Text folding
- Enhanced capabilities for applying color schemes
For details, see our newsletter of january 2006
- Additional Oracle 10 g support: Scheduler, XML
- Integration of the latest version of the Fast Reports 3 report generator
- Explain Plan tree view now presents information about each step in column form
- Integration of new WYSIWYG printing component
- Enhanced performance on Tables page
- Improved functionality in PL/SQL Debugger
- ER Diagrammer now based on new diagramming component (FlowChart)
For details, see our newsletter of january 2006
pre-release since 10-Nov-05
- KeepTool Version 7 is presented as pre-release at DOAG conference in Mannheim (Germany).
- The standard connection dialog for KeepTool products now provides the Color Theme drop-down box, which allows users to easily distinguish between multiple sessions.
- The Data Contents Browser has been redesigned. Tables and views may now be opened by selecting them from a list and double-clicking. A previously created settings file can now be opened even if some of the tables no longer exist.
- Hora can now be automatically started from the command line with the specification AS SYSDBA or AS SYSOPER. For details, please refer to the "Command line parameters" topic
- SQL Workbench's default node My SQL is now called Personal SQL. This change does not affect current users.
- The horizontal ruler in SQL Editor may now be toggled on or off through the Extras > Additional menu.
- The Connect dialog has been enhanced to allow access through the 10g Instant Client, using a string formatted as host:port/service name.
- Reverse DDL now supports the Tablespace clause for LOB's.
- A problem with importing dates from Microsoft Excel has been corrected.
- In Database > Roles , when System Privileges is selected with the bottom left tab, only the Grantees bottom tab is enabled on the right.
- An Oracle Data Access Components problem that occasionally showed blank cells in the Tables > Data Contents grid has been corrected.
- In Overview Tables , the Case-Sensitive check box in the filter dialog has now been turned off by default.
- The Connect Dialog has added a new field that allows optional entry of a tag whose text will form part of the main window's title bar and the taskbar button for the session.
- Various minor changes to improve efficiency.
- Performance of Tables > Data Contents and the Data Contents Browser has been improved by runtime caching of metadata for subsequent queries.
- The DROP TABLESPACE dialog now offers the AND DATAFILES option for 9i and 10g databases.
- Hora's startup performance has been enhanced by eliminating automatic calls to DBMS_JAVA. On the Extras > Settings menu, it is now possible to set Java Server output on or off separately from DBMS_OUTPUT, and to set the buffer size. The default is now Java output disabled, and DBMS_OUTPUT enabled, with a buffer size of 20,000 lines for each.
- On Hora's Tables page, it is now possible to create primary and unique keys from the Columns > Constraints detail grid, in the same manner as on the Constraints sheet.
- HTML Documentation Generator's connect dialog now offers the possibility of a direct TCP/IP connection.
- A list of the current contents of the Data Contents Browser can now be saved to a user-specified XML file. On re-entering the Browser, all tables and views can be brought back into the window via the new Load button.
- Hora now offers the ability to cancel long-running queries in the SQL Workbench, Tables > Data Contents and the Data Contents Browser. A new checkbox in Extras > Settings asks the user if he wants to cancel the query. It appears after 2.5 seconds in Windows XP, or for all queries in earlier versions of Windows. See the new topic "Cancel Query" for details.
- Enhancements have been made to the customization dialogs for the standalone SQL Editor and to the built-in editor in Hora's code windows, most significantly in the Colors dialog. As a result, new default settings are in place. These may be replaced and saved for future use. Details are available in "Customizing the Editor".
- The Search dialog that can be accessed from the Overview Packages page (described in the dialog "Search PL/SQL Text") now allows for searches within all categories of PL/SQL object, or just within the category pointed to by the bottom tab.
- Hora's settings how add the option of disabling Windows Ghosting. This option affects only Windows XP SP1, and prevents situations where windows cannot be closed after switching between Hora and other Windows applications.
- Another new setting determines whether execution time will be shown in the DBMS_Output window when using the Execute Query function.
- Hora's CREATE VIEW dialog now automatically qualifies the view name with the current schema name. This prevents an Oracle error message that was previously generated when the schema selector box was used to manage another user's schema.
- On Tables > Data Contents and in the Data Contents Browser, a new XML export facility has been added..
- On Tables > Triggers, the display of columns affected by triggers has been enhanced.
- The Reports Facility now permits export to an Excel file, and data fields in the Report Designer include references to variable names.
- In the SQL Workbench's Results grid, the reference to AutoCommit in the window caption has been removed.
- The CREATE TABLE dialog, Tables > Columns , and DDL Generation now allow for input and display of explicit length semantics qualifiers BYTE and CHAR for CHAR and VARCHAR2 datatypes. This is shown in Reverse DDL Engineer and HTML Documentation Generator, in addition to Hora.
- The redundant fields LAST_SEC, THIS_SEC, NEXT_SEC in Overview Jobs have been removed.
- In Users > SQL Area, buttons for Filter, Find and Flush SQL Area have been added.
- On Hora's Materialized Views overview, additional information regarding refresh groups has been added to the grid. A new Logging checkbox has been added to the CREATE MATERIALIZED VIEW dialog. The query that produces the overview for an 8.1.7 database was modified to prevent the display of erroneous values in ALL_MVIEWS.COMPILE_STAT.
- In Tablespaces > Datafiles, a context menu item to drop a tempfile has been added.
- Hora's Data Contents Browser now shows the current row and the number of rows fetched in the status bar in the same way as the Tables > Data Contents page.
- In Hora's Packages page, the source code of a PL/SQL unit that is opened in a separate editor now retains editor settings in the same way as the source code window. The Find Procedure function in the separate editor window now also functions in the same way as on the Source Code tab sheet.
- Check marks in grids are no longer encased in boxes.
- All KeepTool products now support access to the Oracle 10g server via the 10g client's Oracle Call Interface.
- In Hora, a new option has been added to the general options menu that is available through Extras > Settings. AutoCommit causes inserts, updates, and deletes that are made through the grids on Tables > Data Contents and in the Data Contents Browser to be automatically committed. In previous versions of Hora, AutoCommit was automatically in effect. This option may now be set off by unchecking the box.
- For Oracle 10g databases, the status of the Flashback Database may now be viewed through a new tab on the Redo Logs page.
- The context menu for Overview Tablespaces now allows renaming of tablespaces in Database 10g.
- On the Overview Tables tab sheet, three new flags have been added: Dependencies, Compression, and Dropped. The third indicates that a table has been dropped, but not purged, from an Oracle 10g database, and is in the Recycle Bin. On Tables > Indexes, a new Dropped flag indicates that an index has been dropped and is in the Recycle Bin.
- The Oracle Data Access Components used by KeepTool now support Transparent Application Failover (TAF), which automatically re-establishes a connection to the server when the prior connection fails.
- Hora now supports the Oracle Database 10g Server.
- The link to Oracle Reference, SQL Reference, and Error Messages, formerly on the Help menu, has been replaced by an all-encompassing link to Oracle Help from the Search context menu in all of Hora's code windows and the standalone SQL Editor.
- Support for Merant® Version Manager™ has been added in SQL Workbench's File Explorer.
- Hora's Query Builder now allows adding related tables from a selected table's context menu.
- It is now possible to drop multiple objects, or to revoke multiple privileges in Hora, by holding down the Ctrl key when selecting objects. A Confirm drop window is displayed and must be acknowledged before proceeding.
- New filtering options have been added to the Data Contents Browser and the Data Contents sheet of the Tables page. They allow the definition of an ad hoc relationship between tables.
- Both the Data Contents Browser and the Data Contents sheet of the Tables page now
enable the memo editor for columns defined as XMLTYPE, and for tables defined as TABLE OF XMLTYPE.
- In Hora's list-filtering dialogs, reachable via the Data Grid > Filter context menu item or the Filter button on the Speed Bar, two new options are available: case-sensitive and non-matching records.
- The width of columns in all of Hora's grids may now be decreased to allow them to be narrower than the width of the column headings.
- In Hora's Overview Packages, Procedures, Functions sheet, new tabs showing
information taken from the V$DB_OBJECT_CACHE view that pertains to the highlighted item is now shown.
- The source code windows for PL/SQL objects now automatically include a slash (/) at the end, to facilitate execution if they are saved to external files.
- Hora's Schema page has been moved from the bottom to the top of the Additional collection.
- On Hora's Schema page, it is now possible to see DDL for grants of object privileges made by the schema owner to others.
- A new sheet, Schema Triggers, has been added to Hora's Schema page.
- The colors of the type and background in Hora's Outlook Bar are now customizable from the Startup tab of Extras > Settings.
- On Hora's Tablespace page, the Datafiles tab sheet has been enhanced to include STATUS from V$DATAFILE, showing whether datafiles are online or offline.
- Batch invocation of HTML Documentation Generator adds many new options, including the ability to generate an HTML file while bypassing the options dialog completely.
- In Hora's SQL Workbench, support has been added for source code management systems that comply with the Microsoft SCC protocol, beginning with Microsoft Visual SourceSafe.
- Hora's Standard Outlook Bar contains a new item: the Data Contents Browser, which facilitates viewing and updating of several tables or views at once. An option enables automatic filtering to show only rows related to a selected row in the previously viewed table.
- Hora's Data Contents sheet on the Tables page has been enhanced to allow viewing of any user-selected table along with the related detail tables. Also, the Arrange Columns dialog has been enhanced to present two new options for selecting columns to be displayed: Select All and Unselect All.
- The Advanced Button in the Connection Dialog for all three products now gives the user the ability to choose among existing oci.dll files for all Oracle Homes using a combo box.
- In all of Hora's code windows, and in SQL Editor, a new context menu item has been added that will comment multi-line selected text with /* */ symbols.
- For schemas, tables and indexes, Hora now offers new options for analyzing statistics.
- The EMS Import and Export facilities on Hora's Table page and on SQL Results added support for the Microsoft Access (.mdb) format. You must have ActiveX Data Objects (ADO) installed to enable this option.
- In Hora's Data Contents page, TIMESTAMP columns are now correctly displayed when using an Oracle 9.2 oci.dll.
- The Context menu for table shapes in Hora's Query Builder now offers options for presenting the order of table columns.
- Hora's Query Builder now allows for both tables and views to be incorporated into the query.
- Hora now uses the SELECT ANY DICTIONARY privilege (in place of SELECT ANY TABLE) with Oracle 9i databases to determine whether data dictionary views should be displayed for users who have not been granted the HORA_USER role.
- A new option has been added to Hora's Extras> Settings menu. It determines whether a dialog will be presented after each DML statement to enable the user to choose between a Commit, a Rollback, or continuing the transaction until a future time. A commit or rollback may now be done via new Speed Bar buttons or via the File Menu.
- A new context menu item and Speed Bar button has been added to Hora's SQL Workbench. It allows the contents of the code window to be sent to a SQL*Plus session for execution and output to be viewed in the DBMS_OUTPUT window.
- On Hora's Schema> Policy tab, new context menu items to add or drop a security policy have been added.
- On Hora's Tables> Columns page, a new dialog to control the visibility and order of columns can now be invoked by clicking the area in the upper left corner of the grid.
- Hora's Redo Logs page has added a new sheet to show archived log data.
- Hora's Report facility now has the ability to save reports in various formats, including .pdf and .rtf.
- Hora's SQL Query Builder adds a checkbox that allows columns to be used in WHERE clauses without being SELECTed.
- The SQL Editor's customization options (standalone and embedded) now include a new Additional category, where it is possible to set highlighting of the current line on or off.
- The File Explorer in Hora's SQL Workbench now displays additional file types such as .sqs and .tab created by Oracle Designer.
- Several miscellaneous minor enhancements.
- The design of the user interfaces for all of KeepTool's products has been modified to allow the interface to follow the currently selected Windows XP design. In Windows XP, the currently selected tab on all tabbed pages is now outlined in orange. The majority of the icons in all products have been updated to show more detail and more color.
- Hora: The SQL Query Builder has been replaced by a new version that allows tables and columns to be shown graphically, with joins for table relationships being automatically generated. Query Builder now also generates code for cursor "for" loops, in addition to SELECT, INSERT and UPDATE statements. The new facility is covered in the SQL Query Builder topic under Modal Dialogs.
- Hora: New Export and Import dialogs have been added to both the Tables> Data Contents page and the Results grid in the SQL Workshop. These facilities are described under two new topics in the Modal Dialogs: EMS File Export and EMS File Import.
- Hora: A new Report facility has been added to both the Tables> Data Contents and the Results grid in the SQL Workshop. This facility is described in the Modal Dialogs under the new topic Reporting.
- Hora and SQL Editor: A new File Comparison facility has been added to the SQL Workbench. It is accessible from both the SQL Repository and File Explorer tabs, and can be used to compare any two text files. This facility is also available from the File Menu in the standalone SQL Editor. It is described in Modal Dialogs under the topic File Comparison.
- Hora: Two new buttons have been added to the left end of the Speed Bar, and are available for most operations that allow updates by typing in a data grid: Commit and Rollback.
- Hora and SQL Editor: Both Hora's SQL Workbench and the SQL Editor now display column numbers in the code window.
- Hora: The Execute Script function in SQL Workbench now ignores SQL*Plus commands. This allows the SQL commands and PL/SQL blocks in scripts to run without interruption.
- Hora: The Execute Script function now shows results from SELECT statements in the DBMS_OUTPUT window, where they can be further manipulated.
- Hora: A new Schema page has been added to the Additional outlook bar. The page gives information about the status of all objects within the currently selected schema, without regard to the type of object.
- Hora: The Grant System Privileges dialog, found under both Database> Roles and Users> Roles &Privileges, now uses icons to distinguish between roles and privileges, and adds a checkbox to facilitate multiple grants.
- Hora: The Privileges tab of the Tables page has been redesigned to show grantees and privileges through a grid.
- Hora: All grid columns can now be resized. Double-clicking a column boundary will set the column size to that of the largest cell. Pressing the Alt key when selecting a text area with the mouse enables selecting a rectangular block of text.
- Hora: On the database page, port string, version and compatibility have been added. All options, whether installed or not, are shown, with unavailable options in gray.
- Hora: The Schema> Clear Schema menu option now gives detailed information about objects that cannot be dropped, such as public synonyms.
- Reverse DDL Engineer: A filter condition can now be applied when specifying objects to be included individually.
- A new facility for exporting the SQL results grid and table contents to a
Microsoft Excel spreadsheet has been added.
- A new facility for generating new user connections, and for switching new connections within Hora, has been added to the menu bar and to the Speed Bar.
- Syntax highlighting for reserved words in code editing windows now includes more new 9i words.
- The Current Schema combo box in Hora has been expanded in length, and the schema name, followed by a colon, has been added to Hora's title bar, when a schema other than the connected user's is being viewed.
- Enhancements to PL/SQL Debugger to maintain variable watches in triggers between invocations, and to enable variable watches in global package variables.
- In Reverse DDL, an new option determines whether the check-box list of database objects should appear checked or not checked when opening the application.
- When executing SQL from either the SQL Workbench's code window or the standalone Editor, it is now possible to turn off automatic save prior to execution, through a checkbox in the Extras | Setting menu.
- When updating from the results grid in the SQL Workbench, it is now possible to select either Commit or Rollback after posting changes.
- The "Show exceptions" dialog now considers rows with null values, that don't match unique constraint.
- On refreshing the data grid after dropping a table, the overview page now remembers the row position within the grid.
- On refreshing the data grid after dropping a table, the overview page now remembers the row position within the grid.
- The "Grant" and "Revoke" modal dialogs, available on the Privileges tab of certain objects, now allow privileges to be granted to or revoked from multiple roles or users at the same time.
- Additional columns pertaining to Object Tables have been added to the Overview Tables page.
- The Oracle Online Documentation feature now offers access to all versions of Oracle 8i and Oracle 9i documentation.
- Interface to Resource Manager updated to support new Oracle 9i parameters.
- The Database | Roles page now allows selection of either Roles or System Privileges, in order to show grantees of all System Privileges.
- Oracle 9i support.
- Reverse DDL Generator now creates DDL for tablespaces, and is available through Hora's context menu.
- SQL Logging is now called SQL Recording, and can be toggled on or off through the Extras menu, as well as the SQL Preview window.
- The SQL Repository is now file-based. SQL that was previously stored in the Windows Registry can now be imported. SQL Recording can designate a destination file through the new File Explorer tab.
- New "Code Completion" menu item under "Query" on the SQL Editor context menu. This feature also appears automatically when entering a table name, alias name, or package name, followed by a period, in a SQL statement.
- The DBMS_Profiler package can be invoked through a new toolbar icon from SQL Workbench.
- In the SQL Editor, color-coding now distinguishes between successfully- and unsuccessfully-executed statements. Problem statements can be corrected in the editor window, and the code can be re-executed.
- SQL Editor automatically creates Bookmark 0 in front of the first statement.
- A new two-part combo box appears for selecting the schema to be viewed. The top part lists the most recently viewed schemas. The bottom lists all schemas in the data dictionary that are accessible to the current user.
- The Overview Tables page "Analyze" option allows the DBMS_STATS package to be used for statistics gathering.
- The Overview Materialized Views page now shows privileges granted and the relevant initialization parameters.
- A new tab, "Long Operations," has been added to the Sessions page.
- The Overview Tablespaces page now includes the tablespace number.
- The Triggers and Foreign Keys menu items on the Schema menu have been replaced by Triggers Global Management and Constraints Global Management.
- Improved error flagging for PL/SQL object and trigger compiles.
- New "Update Comments" column on the Initialization Parameters tab of the Database page (Oracle 9i only).
- New "Firing Order" and "Level" columns on the Triggers tab of the Tables page.
- Data that violates constraints can now be updated directly in the "Show Exceptions" dialog of the Constraints tab of the Tables page.
- Views can now be updated directly, using the Data Contents tab of the Tables and Views page.
- Changes to the Tables|Data Contents page:
- The "Create INSERT Script" menu item now prevents all previously hidden columns from being generated. This feature allows partial comparison of tables belonging to different databases.
- The new "Create UPDATE Script" menu item generates a similar script containing UPDATE statements.
- A new "Logging" context menu item allows you to switch tables and indexes back and forth between logging and no-logging states.
- Added a new "Create Export Parameter File" menu item to the Schema menu item of the main form. It allows you to create a parameter file that controls Oracle's export utility for multi-table exports.
- Now you can add new partitions to a Hash-partitioned table using the "Add" context menu item of the table partitions grid.
- Reverse/DDL now allows you to choose between the following methods of computing the START WITH value for sequences:
- Original start value used to create the sequence.
- Last number used: , i.e. the DDL statement starts with the current sequence value. This option is very useful when you first create the schema structure by running the DDL script and then using Oracle's import utility to load the data.
- Always one, regardless of the original start value and the last number.
- The "Change Current Schema" dialog, which appears when you click the schema button at the left of the status bar, has been replaced by a combo box. It has a built-in most-recently-used list that eliminates the need for the dialog.
- The Tablespaces|Datafiles page now shows the high-water mark for each datafile. This is the absolute number of bytes used, including the free chunks between used data blocks. You can shrink the size of a datafile down to at least this size.
- When a table is moved to another tablespace, its indexes must be rebuilt. We have added a grid to the "Move Table" dialog that displays the indexes and their tablespaces. You can use the check boxes to select which ones should be rebuilt.
- Both Reverse/DDL and the DDL that can be generated from the "Show DDL" menu item on Hora's Users page now support Resource Manager privileges. A call to the Resource Manager package is generated if the user has the privilege of switching to any consumer group.
- A new Hora menu item, Tablespaces|Show DDL, has been added.
- Added context menus to the "watches" and "breakpoints" panes of the PL/SQL Debugger, along with the appropriate menu commands.
- The PL/SQL Debugger now supports server output for Oracle 8i databases. Whenever the Debugger stops, lines written to dbms_output are displayed in the new dbms_output window.
- The new resource manager page gives you an interface to manage the hierarchy of resource plans and assoziate them with consumer groups. You can define a default consumer groups for a users and switch the consumer group of a session.
- The interface to auditing has been improved. You can define audit options of database objects, for example tables, procedures, directories. Additionally, you can define auting of statements and privileges for each user. The auditing page gives you an overview of audited objects, statements and privileges in the entire database.
- Some problems with local managed temporary tablespaces are resolved.
- The tablespace context menu now allows read-only and read-write switchment of the tablespace.
- Added an overview register to the performance page. It displays the numeric values from the other pages.
- As known, Reverse/DDL generates CREATE ROLE statements for the roles granted to the schema owner. Now it generates also GRANT statements for the system and role privileges that are granted to the role.
- Added an "extents" grid below the tablespace fragmentation grid that shows all extents possessing the selected fragment size.
- The PL/SQL call interface page now supports PL/SQL record parameters.
- Added a new context menu item "Visible Columns ..." to the data contents grid. It opens a modal dialog for changing the order and visibility of the columns.
- New page Sessions|Transactions.
- The titles in some data grids are now displayed and managed hierarchically. Related fields are grouped together. Also for header dragging operations, the grid more clearing indicates the new placement of the column.
- A new context menu item "Data Grid | Revert to default column positions" restores the default column positions.
- Some problems with Oracle 9i client software are resolved now.
- The data contents page now remembers changed column positions for each table until the end of the session.
- Considering the columns of the "overview sessions" page that show information about a file path, for example the client application name. In earlier versions the text has been truncated from the right, if the cell width was too small to display the full path information. Now Hora preserves the right part of the path and replaces the middle of the string by two dots. That allows you to read the file name rather than the less interesting path information.
- The new "Materialized Views" page replaces the "Snaphots" page on Oracle 8i databases.
- Reverse/DDL now generates Materialized View Logs and Materialized Views on Oracle 8i databases.
- Added the "Show DDL" context menu item also to the Sequences, Synonyms, Jobs, DB-Links, Materialized Views, Materialized View Logs, Directories, Libraries and Users pages.
- In Hora you can right-click any table now and show the appropriate DDL statement.
- Reverse/DDL now supports partitioned tables.
- The representation of table and index partitions in Hora has been improved.
- The connect dialog now allows you to change the connect mode between normal, sysoper and sysdba. That is needed to connect as SYS to an Oracle 9i database.
- The ASCII export dialog now remembers the settings of its last usage.
- The explain plan outline now shows to each node the number of affected rows (cardinality) and the optimizer costs. The tree can be saved into an ASCII file using the right mouse button context menu.
- The Create Tablespace Dialog now follows the term SAFE (Simple Algorithm for Fragmentation Elimination, see Oracle paper #711 on technet.oracle.com)
- The Tablespaces|Segments/Extents page now displays statistics about the number of segments and the amount of data that has been occupied by each owner and several segment types. The subordinate grid shows only the segments of the preselected type.
- The new Tablespaces|Fragementation page shows statistics about the number and size of used extents and free chunks within the tablespace.
- User's account now can be locked and unlocked. Locked users are displayed in grayed font.
- Added an incremental search dialog to each MDI child window that has the A..Z navigation buttons in the left, and an overview and multiple detail panes. It comes up when you press a letter key while the overview grid has the focus.
- Added a new context menu operation "Result to Logfile" to each grid. It fetches the entire result set from the server and dumps the data to the log file.
- Added "File|Disconnect" menu item to Hora and the standalone SQL editor.
- The Templates directory (CodeSnip.txt, etc.) is now customizable using the "Extras|Settings" menu item.
- Reverse/DDL now supports nested tables.
- A new menu Item Help|System Environment Information shows details about client and server configuration. Please attach the information to any customer support request.
- Since version 5.0 the updatable data grids on both SQL and Tables-Contents pages check, if the record has been changed by another user. You can disable this behavior now by a checkbox in the Extras|Settings dialog.
- New DB drag/drop object browser tool window available from each embedded and standalone editor.
- Ability to edit different PL/SQL objects in separate editor windows.
- Enhanced support for partitioned tables and indexes.
- "F5" button refreshes current page from database.
- Oracle 9i support.
- Network licencees now can work offline from the network for a maximum period of 30 days. This period can be renewed as soon as the application runs in the network environment again.
- Support for creation of local (partitioned), bitmap, reverse or function based indexes
- Fixed some problems with the new licensing procedure affecting certain hardware
- Some minor ease-of-use enhancements
- The new gateway to the Oracle Documentation is now accessible from any location outside of the Oracle home directory, for example, from a central directory in the intranet.
- Added a Favorites page to the outlook bar that is full customizable by the user.
- Version 5 officially released
- HTML documentation generator now supports views
- Online help is now context sensitive
- The connect dialog now remembers the most recently used connections hierarchically. They are ordered first by server names, then by the schemas accessed.
- Fixed workstation and floating network licenses
- Explain plan dialog displays the current session's optimizer mode.
- Tablespaces|Datafiles and Database|Datafiles grids show backup status
- New Snapshot Logs page
- PL/SQL editor remembers the insertion point location in each PL/SQL object until the database connection is closed.
- LOB detail information page below Tables|Columns
- Gateway to the ORACLE online documention made accessible from the Hora Help menu
- The Database links overview page shows some local settings like global_names and default domain initialization parameters in the bottom area.
- ER diagrammer now can print over multiple pages.
- Pre-Release at Oracle OpenWorld, Berlin, June 2001
- Release announced for September 3, 2001
- Connection to database optional without SQL*Net(direct TCP/IP)
- Data grid item menu within each database grid:
- record view
- ASCII export (Excel, etc.)
- Fixed anchor columns
- Row height (variable number of lines)
- Tables page changes:
- Improved create table and create view dialogs
- Create index on FK columns using the FK context menu
- Support for partitions and subpartitions
- Search column, constraint, index or trigger names
- Multiline data contents column captions allow smaller column widths
- Filter by selection extended by a query condition preview dialog.
- New Access detail page
- Deferrable Constraints Support
- Set column unused
- Disable constraint cascade
- Checks if record was changed by another user in data contents
- Returning clause used in data contents
- Detail subpage in data contents view
- Referenced Constraints subdetail page
- Move table to another tablespaces
- Column histograms
- New Java objects page
- Summaries page
- Jobs &Pipes page
- New "All users" tab to display all jobs
- Tablespace page changes
- Sort segments and sort usage subpages
- DbLinks page changes
- Distributed transactions
- Users page changes
- Schema triggers
- SQL area
- Database page changes
- Enable/disable restricted session
- Control file space totals
- Control files can be backed up to trace
- Database triggers
- Separate instance page
- Data files page
- Session page changes
- in statistics page : class info column factored out into a master grid
- RedoLog page changes
- Changes grouped by hours to show peaks in the log activity.
- Log Miner page
- SQL page changes
- &Macro Macro substitution
- Describe and columns dropdown lists now support synonyms
- Stay on top option for query result set window
- Reverse/DDL changes
- support for database and schema triggers
- Deferrable Constraints Support
- Data grid item menu within each database grid:
- enhanced navigation
- copy to clipboard in meta file format
- Bug fixes regarding the Oracle 8 object types and tablespace quota management
- Complete new Online Help for all tools (IE3.0 or higher needed)
- Enhanced data grids
- Version is based on ODAC 2.50 database access components
- Reverse/DDL: several improvements.
- Several bug fixes and enhancements
- Automatic coloring of entities of principal importance in ER Diagrammer. A special algorithm gives tables with strong connections the same color.
- Print functions: several improvements
- Enhanced ER diagram subset definition support
- Improved ER Diagrammer automatic layout
- Version is based on ODAC 2.20
- HEdit: First 80 characters are shown in the status bar
- Jobs are cleared with the clear-schema function
- Dialog job/properties improved
- Generation of PL/SQL call interface improved
- Print function for data content improved
- Minor bug fixes
- Problem with large PL/SQL packages solved
- Print function improved
- New combo box for search function
- Word wrap is activated on the "sessions", "open cursors" and "SGA" screens
- "Rebuild index" dialog is now part of the "properties/alter index" dialog
- The target session is automatically stopped when the debugger session is finished
- Bug fix: print function
- Some minor bug fixes
- Windows 2000 - tested
- New page "Synonyms"
- Redo log page shows special InitOra parameters. These parameters can be changed
- New modal dialog on PL/SQL page: "grep" to find expressions in PL/SQL packages
- SQL Query: No autocommit after execution. After execution, the number of affected lines is displayed and the commit must be confirmed, otherwise a rollback will be executed. SqlQuery with "live" result set still uses autocommit.
- SQL Query: Position of syntax error is displayed
- Editor: The dialog GotoLine now works with a combo box that contains the last used line numbers in a dropdown list.
- Reverse/DDL: IniTrans, PctUsed, PctFree will not be generated as long as generation of storage paramters is deactivated
- Reverse/DDL: Generation of Grants may be prevented by checking a checkbox.
- Statement CREATE_ANY_TRIGGER as part of Role "HoraUser" only as comment.
- On DB Links page, the view UserSnapshots is used instead of AllSnapshots, field "StartWith" is displayed.
- New filter on Table | Contents page: You may right-click one item, and using "Filter By Selection" only the rows that match the selected item are shown.
- Programming of KeepTool 4 version 4.1 now with Delphi 5
- Completely new design for the Editor
- Some bug fixes on SQL page
- Reverse/DDL: Generation of tablespace parameters and storage parameters can be deactivated.
- "Drop Column" is now offered with ALTER TABLE (Oracle 8i only)
- New feature: On Delete Set Null
- HEdit: All buttons are now context-dependent.
- PL/SQL-Debugger out now! Oracle Server Version 7.3.4 or higher is needed for the debugger.
- Tables|Contents: You can enter decimal places in columns of type NUMBER (without precision/scale)
- HEdit: At execution time the character "/" will be interpreted as "end-of-statement" only if it is placed in the first column
- After selection of all Tables/Views, ReverseDDL selects only the appropriate comments
- The event ColumnHeaderClick (which changes the sort order) will not be triggered after moving columns.
- EXECUTE SELECTION on the SQL page
- Recall buffer for the most recently executed statements on the SQL page
- New feature: By using the context menu (Properties/Alter/Rename), all constraints can be renamed and modified. Now it is possible to change a foreign key to "cascading" and to change the search condition for a constraint. In case of error, the existing constraint will be restored. Before renaming a primary key, dependent foreign keys must not exist.
- Bug fix: Color coding on the Tables|Triggers page was corrected. Triggers with errors are now shown in red; invalid and disabled triggers in gray.
- Bug fix: named constraints are now detected or shown using the reverse.sql script
- After successful compilation of a PL/SQL package, the cursor is now positioned where it was previously
- In all grids, sorting is down by clicking on the title of the grid column
- ER Diagrammer:
- Bug fix: Now the cursor moves together with the shape
- The default zoom factor can be chosen; auto zoom can be deactivated
- SanpToGrid, GridVisible, and GridSize can be adjusted
- Bit maps can be deactivated
- General advantages of version 4:
- MDI technique
- direct access to Oracle via OCI (Oracle Call Interface), no BDE needed
- Lower space requirement for installation (5 MB instead of 7MB)
- better performance
- better support for Oracle 8 features
- light version of the ER Diagrammer is part of Hora 4
- Pre-Release of the PL/SQL-Debugger is part of Hora 4
- Hora 4 contains a light version of the new product ER Diagrammer