- 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.
- 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 to the Windows clipboard an expdp or impdp command template for table export/import.
- 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.
- 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.
- KeepTool 11 is now available as a native 64 bit application.
- Our new version is packaged in 3 editions:
- Light Edition
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)
- Light Edition
- 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
- It shows a list of changed objects
- For each changed object you can see syntax highlighted DDL statements side by side, whereas different background color indicate the added, removed and changed parts.
- The 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.
- Create an update script to synchronize structure (basic support)
- General changes
- Modal dialogs for renaming Oracle objects now show you the current utilization of the 30-character-limited length for the new identifier
- Each 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.
- For 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.
- For 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.
- The 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.
- New context menu items have been added for creating and dropping synonyms for all granted or all not granted objects.
- A new tab sheet shows unusable indexes.
- The new menu item Schema | Mask Schema Data opens a wizard that helps you to anonymize your database.
- A new menu item Schema | Recently changed objects shows you a list of recently changed database objects including time stamps.
- Hora 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:
- Table description
Copies the column definition of the table into the clipboard
- MERGE statement
Creates a MERGE SQL statement for the selected table
- WHERE condition
Creates a template for a WHERE condition that includes all columns
- Copy 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:
- Sequenced PK trigger wizard
It helps you to create a trigger that fills the primary key column from a sequence value.
- Mutating 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.
- Instead 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
- A new menu item in the SQL editor “Selected object | Expand CURSOR FOR LOOP” changes the selected table name to a CURSOR FOR LOOP statement.
- Double-clicking a word in the SQL editor highlights all occurrences of the word in the editor.
- The Query generator now optionally speaks ANSI SQL (INNER JOIN, etc.)
- The query execution plan now can be exported to Excel
- The SQL Query builder now uses a blue font for not null columns.
- Data content browser and SQL resultset grid
- The tree view now shows different cell background colors depending on the indention depth. This makes it much easier to understand the tree structure.
- The Excel export option is now also available for the tree view as well.
- The SQL recording now also keeps track of DML changes made by editing data in content grid
- Besides the INSERT and UPDATE script, you can now generate a MERGE and a DELETE script from the data content grid.
- The 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
- Shows views in a separate list.
- Shows cross-references between tables/views and PL/SQL objects.
- View and package definition now uses syntax highlighting.
- Spatial data support
- The create INSERT script command now supports the SDO_GEOMETRY data type.
- A new context menu item both data contents and SQL query result set grid allow structured SDO_GEOMETRY data view.
- A new Tables | Columns | Bounding Rect sheet shows the bounding rectangle for spatial columns (ALL_SDO_GEOM_METADATA).
- A Context menu item copies an INSERT statement into the clipboard for transfering the bounding rectangle to another database.
- Another context menu item allows you to export spatial data from a field to a KML file that can be opened in Google Earth.
- A 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.
- On 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
- The error highlighting now uses more subdued colors.
- The height of the PL/SQL error list is now automatically adjusted according to the number of errors.
- PL/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.
- PLSQL 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.
- PLSQL 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.
- Red highlighting of erroneous objects keeps as is, but uses a more subdued hue.
- Recently changed objects that are currently invalid are highlighted in yellow color instead of green.
- The PLSQL 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:
- transaction+active: green
- in transaction+inactive: yellow
- The sessions page now shows the service name. A checkbox marks sessions running locally on your machine.
- Reverse DB now generated PLSQL 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
- Compatibitily for Oracle 18.104.22.168
- Our new setup procedure includes also HoraLight.
- Compatibility update for Microsoft Microsoft Security Advisory (2896666) to circumvent „Invalid Operation in GDI+ (Code 1)” error on some older Windows versions.
- Kill-Session menu item has been enabled for multi-select.
- Significant performance enhancement on sessions|overview and SGA|sql area pages.
- Enabled for Oracle 12c and Windows 8.
- Hora's "Create table from import source" command now has been enabled to process CSV files besides MS-Excel and MS-Access sources.
- Unusable indexes are highlighted using red font.
- When exiting Hora while a transaction is still active you will be asked weather to commit or roll back.
- 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 js.
- 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.
You can find the previous release notes here.