EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

Product News

SQL Manager for Oracle version 2.5 released

We are pleased to announce the new minor version of SQL Manager for Oracle - a high performance tool for Oracle database server administration and development.

You can download the newest version of SQL Manager for Oracle from the download page.

What's new in SQL Manager for Oracle 2.5?

  1. Added the new objects: Queue and Queue Table.
  2. Added the TKProf Wizard to work with TKProf program for handling trace files.
  3. Backup Database Wizard. The possibility to schedule the backup process is added.
  4. Visual Query Builder. If a file is opened, its name is displayed in the window title.
  5. Now SQL Manager does not execute “Alter session set …” queries under the Normal User as they used to result in the “ORA-01031: insufficient privileges” error.
  6. The speed of working with the object tree is increased. The work of the Normal User is optimized.
  7. SQL Script Editor. Added the support of the “/” delimiter for all objects.
  8. “Edit Local Naming Parameters” option is added to the main menu.
  9. Added the possibility to change the password for the Normal User.
  10. The work with two registered databases that had the same ServiceName caused to the “SQL command not properly ended” error if the Schema Restriction option was enabled. Fixed now.
  11. When importing data from the CHAR(1) field with the value of ' ' (a space), this field was imported as empty. Fixed now.
  12. Visual Query Builder. When pressing the Clear button, the query type was not reset to “Select”. Fixed now.
  13. Array Types Editor. The list of objects for quick switching was not filled. Fixed now.
  14. After refreshing and disconnecting from a database and closing SQL Manager, an error occurred. Fixed now.
  15. When moving to the Permissions tab under the Normal User, the ORA-00942 error occurred. Fixed now.
  16. Materialized Views.
    • When creating a materialized view, an extra “;” was added to the DDL description and an error occurred. Fixed now.
    • When deleting a materialized view whose editor was running, the DDL of the non-existent view was generated. Fixed now.
  17. When editing a function, the “There is an error in input of field…” message appeared. Fixed now.
  18. When trying to connect through SSH, the “ORA-01031: insufficient privileges” error occurred. Fixed now.
  19. When the “Hide empty schemes” option was enabled, the current user scheme was hidden if it did not contain any object. Fixed now.
  20. Tablespace Editor. If you did not go to the Files tab, data files were not displayed in DDL. Fixed now.
  21. Other small improvements and bugfixes.

We hope you’ll enjoy working with our products!