KeepTool Blog - Current

ER Diagram creation for Oracle databases can be automized by our KeepTool ER Diagrammer that is part of the KeepTool Enterprise Edition. In an instant, the tool creates a properly arranged Entity-Relationship Diagram by reverse engineering your database. This is very useful for data modelling, understanding an unknown legacy database, and for documentation purpose. [...]

Reverse Database Engineer is part of both KeepTool Professional and KeepTool Enterprise editions. Since all our tools benefit from our continual improvement strategy, version 14.1 comes with an important new feature. Reverse DB allows you to create a DDL script for an existing Oracle database schema or any subset of selected objects. That is a very powerful option for any database developer, because you can run the script later on another machine to re-create the database structure, or simply retain the script as part of your backup strategy. [...]

Oracle blocking session analysis is a most common task in many database systems having a high concurrency between Oracle sessions and update contention. If a database session blocks a record for an extended period of time, this can have highly negative consequences – even affecting a productive system in the worst case. It is therefore very important to quickly identify the cause behind such blocks. [...]

Over the last years, KeepTool has developed powerful import and export functions to make the use of Excel files in combination with Oracle databases as convenient as possible. In the latest edition, version 14, these features have been enhanced through additional useful functions. KeepTool thereby offers comprehensive functionality when working with Excel files. [...]

[...]

Data grouping withing Oracle Excel export now can be retained. As you may rememeber, column groupings are available both in Hora’s data content browser and SQL result set view. [...]

KeepTool 14 Data Content Browser now introduces Oracle merged column grouping. [...]

KeepTool is considered a Swiss Army knife for administrative and programming tasks related to Oracle databases. The software supports all Oracle features, and its use is self-explanatory and incredibly simple. “Time and time again, our users confirm that they find their bearings immediately and are able to use all functions straight away, even without a manual,” says Rolf Grünewald, Managing Partner of KeepTool GmbH. Another strength is that customer requirements from daily practice are captured and implemented in a short period of time. KeepTool has therefore been expanded with over 40 new functions in Version 14 and given a new design that further improves user-friendliness: “The version released on 25 June 2018 is already proving to be extremely popular.” [...]

The name of the generated .sql file containing your Oracle database structure backup in this case is [...]

[...]