Oracle Tools

Loading Oracle LOB Data – Code Samples

Recently we were working over the release of the version 2.0 of  dbForge Data Compare for Oracle. One of the main features added to the new version was synchronization of the LOB data. When we developed the first release of the product we postponed this feature because of challenges of synchronizing LOB data. These challenges caused by nature of data stored in BLOB or CLOB columns. It’s large and simply does not fit into SQL script. But we’ve found the solution.

In this article we will examine basic methods of loading LOB data into a table.

(more…)

Oracle DBMS_COMPARISON package overview

During replicating data in one or another way, it happens that synchronized objects may differ. This situation may take place in the following cases:

  • If changes made in one of copied databases were not captured
  • The changes were captured but not forwarded
  • The changed were forwarded but not applied due to some reasons

It should be admitted that full or partial synchronization may be required due to some other reasons, not related to replication. But the question is how to synchronize database objects?
(more…)

10 Ways to Synchronize Oracle Table Data

In the process of developing databases many developers and testers encounter a problem of synchronizing data between local and remote Oracle database. Changes made in a local database must be reflected in a remote database. It’s also necessary to check test results with the model database, to find non-synchronized tables that appeared after these tests, to have possibility to return the test database to its initial state when testing newly developed versions of databases intensively. Another problem may be to create CRUD operations quickly without making too much effort to find different objects and to write DML statements. Now let’s find out how one can synchronize data of Oracle databases.

Simple solutions:
(more…)

How To: Disable All Foreign Keys in Oracle Scheme

When you perform data maintenance operations, sometimes, it’s necessary to disable or enable all foreign keys in the user schema.

Here is the script that solves this task:
(more…)

Devart Unveils Free Data Compare Tool for Oracle to Bring High Speed and Adjustable Comparison

Devart today unveiled a new data comparison tool, dbForge Data Compare for Oracle. It delivers automatic data comparison in Oracle databases, provides a convenient GUI to manage the differences, and generates SQL*Plus-compatible synchronization script to synchronize the data.

Read more: dbForge Data Compare for Oracle news…

How To: Kill User Sessions in Oracle

Not a long time ago we started to write auto-tests for testing our new product –
dbForge Data Compare for Oracle. To recreate a schema in Oracle all user sessions should be killed.

To achieve this we’ve written the following PL/SQL script:

(more…)

dbForge Data Compare for Oracle: new life to the product line

Recently our development efforts were focused on dbForge for SQL Server product line. We’ve made five major releases of SQL Server database tools in last 18 months. Besides, we’ve made two major releases of MySQL database tools in this period. Our Oracle database tools product line, once actively developed, was frozen for almost three years. Sure we made maintenance releases, but no new features and tools. Our Oracle tools even were not re-branded to dbForge for Oracle. But now we decided to breeze the new life into Oracle tools development.

The first tool in the dbForge for Oracle product line will be Data Compare. For the first release we decided to make a free tool with basic functionality:

(more…)

Forget about Database Explorer!

Of course, it’s just a joke, but in every joke there is a grain of joke. Remember how many times you wished you never saw Database Explorer again, switching from the SQL script each time to view a required database object. It is really inconvenient to search database objects mentioned in the script using Database Explorer.

Your way out is one-click access to definitions of schema objects and variables from the script. Right-click an object in your code and select the Go to definition option (defaultshortcutF12) from the menu.

SQL: Go to definition option

The object editor or a corresponding DDL script will open in another window.

SQL: Go to definition option in use

Use the same option to navigate to a required object or definition within a script. For example, you will breathe freely moving with lightning speed to alias declarations in complex expressions or to object declarations in the script. For speedy navigation in large scripts use the Navigation bar at the top of the document or the DocumentOutline window.

Welcome!

Welcome to the Devart development blog of dbForge product family.
We’ll publish here articles on development, product usage tips, issue workarounds etc for MySQL, Oracle, SQL Server.