Version 8

<< Click to Display Table of Contents >>

Navigation:  Getting Started > KeepTool Release Notes >

Version 8

Previous pageReturn to chapter overviewNext page

Version 8.1.8 (2009-07-26)

Added support for multiple (comma separated) aliases in TNSNAMES.ORA

XML field data is displayed in grid views similar to CLOB contents. The option "Show CLOB content in grid" has been extended by XML content.

Syntax highlighting for XML field data.

Version 8.1.7 (2009-04-07)

Added show DDL menu item for PL/SQL types

Visual appearance of database and schema triggers reconciled with table triggers

Create foreign key dialog retains referenced table owner for next call

Version 8.1.6 (2009-01-27)

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.

Version 8.1.5 (2008-11-27)

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.

Version 8.1.4 (2008-10-16)

Password change dialog now adds REPLACE clause for Oracle 9.2 or later

Version 8.1.3 (2008-10-06)

Significant performance enhancement when executing scripts with tens of thousands of lines.

Version 8.1.2 (2008-09-17)

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

Version 8.1.1 (2008-07-07)

Improved performance of switching between pages

Database|Datafiles page now includes both datafiles and tempfiles.

"Create table from import" Wizard now automatically ensures table and column names match Oracle naming conventions.

Improved tooltip hints in ER Diagrammer

Data grids allow inplace-editing of table and column comments

Several minor tweaks fixed.

Version 8.1.0 (2008-06-04)

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  (excluding 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

System environment information dialogs shows additional information such as video card and disk space.

Version 8.0.1 (2008-02-15)

Microsoft Windows Vista supported

Support for Oracle 11g virtual columns. The table columns grid shows two new check boxes: "virtual" and "hidden." Use add/change column context dialogs to manage virtual columns

Support for Oracle 11g invisible indexes. The appropriate data 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 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 database links

New  "Create | Table from import" item on "Tables | Overview" context menu. Creates column types that match the import source.

The list box items showing column names in the "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 data file. This means that you will now see segments that prevent downsizing 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 instead of string 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 performance in SQL Scratchpad

Skinned user interface. The settings dialog allows you to change the visual appearance of the application.

New FTP Explorer tab sheet on SQL page allows you to execute scripts right from the server using FTP protocol.

Grant dialog for object privileges has been re-designed.

PL/SQL Procedures/Call interface page now shows authorization method for procedures and functions (Oracle 9i or later).

New tab sheet Statistics Preferences on the Tables page for Oracle 11g. The context allows to change the 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 displays it as check box. The properties context dialog allows changing.

Read-only data content is shown in gray font

DDL generation includes the new property.

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

Query Builder now allows you to save and retrieve a query definition to and 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.

Skinned User Interface. You can select between multiple visual appearances by selecting from Extras|Settings -  Behavior - Skin name.

There are different look and feels available such as Office XP blue, black and silver and a couple of seasonal skins like Xmas and Valentine's day.

New options Extras|Settings - Data Contents - Long Numbers as String (default: True). The option defines how different precisions of Oracle's and Window's numeric data types are handled. If checked, long Oracle NUMBER columns are displayed as strings without loosing precision. As a result, calculated footer totals are not available. If unchecked, long NUMBERs are mapped to Windows' double data type with 15 significant digits. Totals such as SUM and AVG are available, but precision may be lost.