Blog 2017

Oracle initialization script

Execute Reverse DB from a batch file

09 Feb 2017

In this example, we would like to show you a sample how to use a Windows batch file to execute the Reverse DB Engineer on a regular basis and store each resulting script as a date-stamped file for future reference. Note the RevDDL executable has been passed two parameters: the name, including path, of the […]

Find Oracle columns that would exceed byte length in multi-byte character set

Avoiding character set conversion pitfalls when migrating to Oracle 12c

08 Feb 2017

Over the course of the past year 2016, some of our customers have shared with us their experiences with database migration to Oracle 12c. In most cases the customers installed a new pluggable 12c database rather than upgrading the existing database. After that, they transferred data using export and import utilities. ‍ One issue that […]

Oracle initialization script

Running an initialization script after connecting to the database

07 Feb 2017

KeepTool 12.1.3 introduced the ability to designate an initialization script to run immediately after logging on to Hora. For each database connection, an initialization script can be set in the expanded section of the Connect dialog window: Although you may already have some ideas in mind for using this feature, we’d like to mention two […]