Version 11

<< Click to Display Table of Contents >>

Navigation:  Getting Started > KeepTool Release Notes >

Version 11

Previous pageReturn to chapter overviewNext page

Version 11.2.4 (2015-10-22)

Oracle home selection is now based on Oracle home names instead of OCI DLL path.

Added a new SQL*Plus inspired switch “Set Echo” to the settings | SQL page sheet. When activated, it logs executed SQL text to the dbms_output window.


Version 11.2.3 (2015-08-03)

The Excel export directory can be changed now by settings. It defaults as before to the user’s temporary directory.

The “filter by selection” dialog now comes up with pre-selected filter value rather than selecting the entire filter condition. That makes it easier to change the value.

The “execute script” command on the SQL page now supports both Oracle SQL*Plus parameters TIME and ECHO in a similar way. Defaults can be set on settings page.


Version 11.2.2 (2015-07-10)

ELM (CrypKey Enterprise License Manager) has been enabled for network license transfer.


Version 11.2.1 (2015-04-07)

New KeepTool launcher app to start all tools from a central place.


Version 11.2.0 (2015-01-21)


The Network license is now based on TCP/IP. To upgrade, please uninstall version 11.0 and then install 11.2 on both server and all clients. See Installation and Licensing Guide for details.

Improved representation of chart views on data content and SQL query result pages.

Single sign on has been implemented for KeepTool applications started from Hora’s tools menu. Our tools (except DbCompare) will get passed Hora’s connect string.

Data grid content is now painted by the selected skin. This gives you a smoother look and feel. Use the unskinned interface to benefit from all available color highlightings.


Version 11.0.8 (2014-11-24)

CrypKey network license server has been updated to version 7834. This eliminates some tweeks that occurred under rare conditions. You can either update your server using the setup procedure or stop the CrypKey Windows service temporarily and manually replace the crp32002.ngn file in the %PROGRAMDATA%\KeepTool11\License\ directory on the server. You find a copy of this file on your updated client (file date 11/11/2014).

The Network License Manager does not take its own network seat any more.

The network client configuration now allows you to configure an alternative network license server to failover when the default server is not available.

Schema | Spatial Columns | Copy INSERT script to clipboard menu item logic has been improved.


Version 11.0.7 (2014-10-07)

Similar to tables, packages and other objects, the “users” page highlights recently created accounts using three graded shades of green.

User accounts having their password expired are highlighted yellow. Within grace period, highlighting starts with reduced intensity.

A new overview tab sheet on the schema page shows a summary of the status of various object categories.

Setup procedure is now digitally signed.

New last login timestamp column on “users” page for Oracle 12c DB.

Improved calculation of the “predefined” column on users and roles grids for Oracle 12c database.

New context menu item “Reset current password ...” on users page to reset the existing password, e.g. when expiration within grace period.

Improved performance on database | roles page.

Network license now can be transferred to another machine.

You can now use different editions with different users simultaneously on the same machine, e.g. when using terminal services. See new chapter “Multi-user environment on a terminal server” in our installation and licensing guide for details.


Version 11.0.6 (2014-09-12)

Schema | PLSQL errors page uses color highlighting similar to the error list below the code editor window.

The Recently changed objects list has been removed from the main menu item and integrated as a new tab sheet on the Schema page. Many minor improvements have been applied such as using timestamp column instead of last DDL column.

Introduced a new option SQL page | auto-show dbms_output window. When unchecked, dbms_output window is not automatically shown.

Hora’s main window caption now shows the Oracle edition (e.g. EE, SE, XE) next to the Oracle version number.

Direct TCP/IP connectivity now processes NLS_LANG environment variable.

A new RMan page has been added showing rman backup job details.

The object dependencies tab on the tables, PL/SQL and other pages now shows additional information about the dependent object such as “valid” and “has errors” flag and uses color highlighting to reflect these flags.

The green “confirm last DDL highlighting” buttons on Tables, PLSQL and Schema pages have been consolidated into one single button. You can find it in the main menu next to the commit/rollback/refresh buttons. It toggles between 4 states now when clicked without pausing. That allows you to reduce the intensity of highlighting down to zero and after that it returns back to full intensity. Next changes on objects are always highlighted again in full intensity. You can disable the feature by unchecking an option in the settings dialog

Added a new main menu group “Tools | Oracle Tools” with menu items “SQL Plus” and “RMan” to run the appropriate Oracle tools from the currently used Oracle home. They are not available for direct TCP/IP connections or when the appropriate tools are not found in the Oracle home.

Added a new main menu group “Tools | Database Server” with menu items “Remote Desktop Connection” and “Explore Shared Folders” and “Manage Windows Services” to run the appropriate Windows tools on the database server

INSERT/UPDATE/MERGE scripts created from data content now declare a PL/SQL variable for spatial data to avoid SQL array size restriction.

Recently changed synonyms and sequences are now highlighted similar to the highlighting of tables, views and PL/SQL objects.

The appearance of selected connections in query builder has been improved.


Version 11.0.5 (2014-08-04)

The menu item Table | Column | Lob segment | Move tablespace is now also available from the tablespaces | segments data grid.

A new option allows you to configure the PL/SQL page to show procedures and functions on separate tabs.

Improved network license handling.

Data Content Browser now shows for each table a detail grid showing table columns.

A new tabsheet users | proxies shows proxy user relations the current user is related as proxy or as client.

New modal dialog to change refresh options of a materialized view.

A new button on the “Show exceptions” dialog copies a SQL statement to clipboard that selects all records with the appropriate constraint columns.


Version 11.0.4 (2014-06-06)

On the SQL page you can use now the ESC key to close the (undocked) SQL result set window. A new setting controls this behavior.

Added a checkbox to the “search DB for string” dialog that allows you to search for a SQL expression rather than a fixed string. This allows you to find special characters by using the CHR() function.

Some minor enhancements to the licensing dialogs.


Version 11.0.3 (2014-04-22)

Improved application startup performance.

DbCompare supports additional Oracle database objects.

Both data grids on Data Content and SQL Scratchpad hide their filter row for empty result sets to avoid accidently data input.

Added basic integration of TortoiseSVN version control to the SQL scratchpad repository. Either use the “run Windows Explorer” context menu item or the integrated File Explorer on the next tab sheet to access the full list of TortoiseSVN commands from the Explorer context menu.

A new menu item on the SQL scratchpad tree view opens the repository item on the integrated file explorer. Another menu items runs Windows explorer separately.

Create Insert/Update script commands now omit read only view columns from SQL generation.

File explorer on SQL page shows the location using a bread crumb editor.

Both Tables Data Content view and SQL query result set view show a bread crumb path together with the tree view. You can select the field the bread crumb view is based on from a combo box.

Standalone SQL editor shows bread crumb editor to navigate SQL file path.

DB Compare allows you to exclude tablespace and storage clause from comparison.


Version 11.0.2 (2014-03-24)

The database page got a new tab sheet showing database contexts.

Both users and database|roles pages show a new checkbox “predefined”. It is checked for users and roles that are preinstalled with your Oracle database. Please report any missing user names and roles. Since there is no data dictionary information we manage our own list.

The users overview grid has 3 new context menu items that copy to the Windows clipboard either the list of selected usernames or an expdp / impdp command template for schema export/import.  

On the tables page you will find a similar new context menu item to copy an expdp or impdp command template for table export/import to the Windows clipboard.

User account lock/unlock menu items have been enabled for multi-selection.

There is a new button on the database page next to the host name text box. It opens a Windows explorer showing shared folders on the server. This can be used to access the data pump directory or to read server log files. Another button opens a remote desktop on the server if it runs on MS Windows and allows RDP connections.

Most data grids now can be exported to MS Excel using Ctrl+Shift+E shortcut or context menu item.

Invalid Materialized Views are displayed in gray font on the Materialized Views overview sheet.

After a SQL snippets has been generated and copied to the Windows clipboard, a tooltip hint shows up in the lower right.

There is a new checkbox column on the tablespace page that is marked for permanent tablespaces containing application data, i.e. all permanent tablespaces except SYSTEM, SYSAUX and USERS. This allows you to filter your own tablespaces by a single mouse click.


Version 11.0.1 (2014-03-10)

Both Reverse DDL and the Show DDL command on the “users” page now create DDL for schema triggers.

The data content grid view now use gray font for view columns that are read-only. It is based on information from ALL_TRIGGER_COLS for views that have instead-of-triggers and from ALL_UPDATABLE_COLUMNS else.

The Representation of AWR snapshots has been changed. For each snapshot you can see now “DB time” as well as the length of the snapshot interval. An embedded progress bar shows the ratio of DB time and interval length to measure database utilization. A pie diagram shows percentages of parsing schemas.

Archived Redo Log files are now grouped by day to show you the daily amount of disk space needed.

You can run now multiple instances of the network license server on the same machine supporting multiple editions. The network license manager allows you to switch between editions. The single edition procedure still works but is marked as deprecated.

DB Compare now allows you to select which object types it will compare. This may speed up work with very large databases with 10,000 objects and more.

The green color that has been introduced to highlight the last changed objects now uses 3 differently graduated hues for changes in the last recently 1, 3 and 10 days. The button to confirm last DDL changes accepts just one level. You may need 3 clicks to reset all 3 highlighting levels.


Version 11.0.0 (2014-02-17)

KeepTool 11 is now available as a native 64 bit application.

Our new version is packaged in 3 editions:

oLight Edition
(contains HoraLight)

oProfessional Edition
(contains Hora, SQL Editor, Reverse DB and HTML Doc)

oEnterprise Edition
(contains Hora, SQL Editor, Reverse DB, HTML Doc, ER Diagrammer, Debugger and new DB Compare)

We use a new licensing procedure that allows license transfer between workstations and a more flexible license management.

KeepTool 11 supports touch screen gestures.

Support for Oracle 12c database and 12c client software has been added.

Support for IP V.6 has been added to the direct TCP/IP connectivity. You can change between IPv4, IPv6 and IPBoth in the settings.

The Direct TCP/IP option now supports connections via service_name or instance by using a syntax like



Our new DB Compare tool allows you to compare databases

oIt shows a list of changed objects

oFor each changed object you can see syntax highlighted DDL statements side by side, whereas different background color indicate the added, removed and changed parts.

oThe indicator area next to the scrollbar visualizes the region of source code that is captured by the visible editor area and where changed source has been changed.

oCreate an update script to synchronize structure (basic support)

General changes

oModal dialogs for renaming Oracle objects now show you the current utilization of the 30-character-limited length for the new identifier

oEach Hora page now shows information about the database connected to. This is helpful when running multiple KeepTool instances against different databases at the same time.

oFor Windows 7 and later our tools now make use of progressbar animation in the Windows taskbar when perfoming data dictionary scans in RevDDL, ER Diagrammer, DB Compare, HTML Doc.

oFor SYS and SYSTEM users you can configure now a separate start page. By default it shows the SQL page instead of the tables page.

Changes on the schema page

oThe schema privileges cross table view now uses a different background color when the user has a private synonym for the object. That allows you to view both private privileges and synonyms in a single grid view.

oNew context menu items have been added for creating and dropping synonyms for all granted or all not granted objects.

oA new tab sheet shows unusable indexes.

oThe new menu item Schema | Mask Schema Data opens a wizard that helps you to anonymize your database.

oA new menu item Schema | Recently changed objects shows you a list of recently changed database objects including time stamps.

oHora now remembers a “current schema” change from the last session and asks you when connecting again if you want to change the schema.

Several new context menu items have been added to the Table | Copy to clipboard  menu on the tables overview page:

oTable description
Copies the column definition of the table into the clipboard

oMERGE statement
Creates a MERGE SQL statement for the selected table

oWHERE condition
creates a template for a WHERE condition that includes all columns

oCopy to clipboard | CURSOR FOR LOOP
Creates a CURSOR FOR LOOP statement for the selected table.

Read-only columns are now displayed using a gray font.

The context menu on the tables | overview page that generates a SELECT statement now prompts you for an (optional) table alias.

New menu items have been added to the triggers context menu:

oSequenced PK trigger wizard
It helps you to create a trigger that fills the primary key column from a sequence value.

oMutating trigger wizard
It creates a compound trigger to avoid the “mutating error” when updating an aggregated value of the master table value after changes on the detail table.

oInstead of trigger wizard
It is a great help for creating instead of triggers for views.

A new menu item Table | Column | Lob segment | Move tablespace
allows you to move a lob segment to another tablespace

A separate Show DDL menu items has been added for constraints and for indexes

SQL editor changes

oA new menu item in the SQL editor “Selected object | Expand CURSOR FOR LOOP” changes the selected table name to a CURSOR FOR LOOP statement.

oDouble-clicking a word in the SQL editor highlights all occurrences of the word in the editor

oThe Query generator now optionally speaks ANSI SQL (INNER JOIN, etc.)

oThe query execution plan now can be exported to Excel

oThe SQL Query builder now uses a blue font for not null columns.

Data content browser and SQL resultset grid

oThe tree view now shows different cell background colors depending on the indention depth. This makes it much easier to understand the tree structure.

oThe Excel export option is now also available for the tree view as well.

oThe SQL recording now also keeps track of DML changes made by editing data in content grid

oBesides the INSERT and UPDATE script, you can now generate a MERGE and a DELETE script from the data content grid.

oThe Data Content | Create Update Script command now shows you a list of Primary Key and UNIQUE constraints. This allows you to choose which key columns will be used to build the WHERE condition

The generated HTML documentation for the schema now

oshows views in a separate list.

oShows cross-references between tables/views and PL/SQL objects.

oView and package definition now uses syntax highlighting

Spatial data support

oThe create INSERT script command now supports the SDO_GEOMETRY data type.

oA new context menu item  both data contents and SQL query result set grid allow structured SDO_GEOMETRY data view

oA new Tables | Columns | Bounding Rect sheet shows the bounding rectangle for spatial columns (ALL_SDO_GEOM_METADATA).

oA Context menu item copies an INSERT statement into the clipboard for transfering the bounding rectangle to another database.

oAnother context menu item allows you to export spatial data from a field to a KML file that can be opened in Google EarthTM

oA new context menu item in both SQL and data content pages allow you to create a KML file from spatial data for the entire result set.

oOn the Schema page you will find a new tab sheet “Spatial columns” showing all spatial columns of the schema including the bounding rectangle definition from ALL_SDO_GEOM_METADATA and the supporting spatial index. The context menu allows you to create an insert script that also rebuilds the spatial index. Furthermore, you can export the bounding rectangle to a KML file for showing in Google EarthTM.

PL/SQL page

oThe error highlighting now uses more subdued colors.

oThe height of the PL/SQL error list is now automatically adjusted according to the number of errors.

oPL/SQL packages automatically recompile the package body when the package specification has been changed. This shows you resulting errors immediately rather than invalidating the body only.

oPL/SQL packages and bodies as well as procedures and functions are now show on the same tab. This makes it much more easier to switch between package specification and body.

oPL/SQL objects as well as tables/views with LAST_DDL_TIME changed recently are highlighted in green color. Now you see at a glance what has been changed recently. There is a confirmation button that resets highlighting horizon to current date.

oRed highlighting of erroneous objects keeps as is, but uses a more subdued hue.

oRecently changed objects that are currently invalid are highlighted in yellow color instead of green.

oThe PL/SQL page keeps track of the editor scroll position when switching between PLSQL source code of different objects during session

The sessions page introduces new highlighting colors:

otransaction+active: green

oin transaction+inactive: yellow

The sessions page now shows the service name. A checkbox marks sessions running locally on your machine.

Reverse DB now generated PL/SQL code to create Policies

There is a new Active Session History tab on the AWR page.

A new page DBA Container Database has been added for Oracle 12c.