KeepTool Blog - 2014

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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. […]

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 […]

KeepTool 11 is now available as a native 64 bit application. Our new version is packaged in 3 editions: Light Edition (contains HoraLight) Professional Edition (contains Hora, SQL Editor, Reverse DB and HTML Doc) Enterprise Edition (contains Hora, SQL Editor, Reverse DB, HTML Doc, ER Diagrammer, Debugger and new DB Compare) We use a new […]