EMS logo

Products Navigation

choose your database tool

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS News & Events

All News & Events

SQL Manager for Oracle v.1.3 released

We are pleased to announce new version of SQL Manager for Oracle - a high performance tool for Oracle Database Server administration and development.

You can download the newest version from the download page.

What's new in SQL Manager for Oracle version 1.3?

  1. Oracle Client Checker is added to check client and home settings on starting the program. It can also be called from Database Registration Info dialog.
  2. Advanced Statistics Wizard is added to collect, delete and import/export the statistics on specified objects for optimizer.
  3. Truncate Wizard is added for truncating table and cluster data.
  4. Enable/Disable Constraints Wizard is added to disable and enable the constraints of different types (for selected tables).
  5. Procedures and functions are shown as subobjects for the packages in DB Explorer, as well as in the Code Completion list.
  6. The Recompile Invalid Objects service is added, which allows to recompile selected invalid PL/SQL objects.
  7. Code Completion. Now the objects are displayed in Code Completion list even if they were not refreshed in the object tree list of DB Explorer (can be switched off with the help of corresponding option).
  8. Extract Database. Wrong statements for creating materialized views used to be displayed in target script. Fixed now.
  9. When duplicating a table the schema name of the target table was missing in field descriptions, which caused an error on executing the script. Fixed now.
  10. Visual Database Designer. When opening a previously saved diagram the ‘Object not found in database’ error used to occur. Fixed now.
  11. Visual Database Designer. In some rare cases foreign keys were not displayed. Fixed now.
  12. Database Registration Info. The value of the Rollback on Disconnect option was not taken into account in case of emergency disconnect. Fixed now.
  13. When deleting multiple materialized view logs in object tree a wrong script used to be generated. Fixed now.
  14. Fixed the AV error which used to occur on creating a view.
  15. Dependency Tree. It was impossible to open the editor from a diagram for indices and triggers. Fixed now.
  16. SQL Script. In some rare cases the script parser detected object type wrong for materialized views, object types, array types; those objects were placed into the wrong branch in DB Explorer. Fixed now.
  17. DB Explorer. After disconnecting from a database the Recent Objects list remained active. Fixed now.
  18. Other small improvements and bugfixes.

We hope you’ll enjoy working with our products!