The new version 3.2 of EMS SQL Manager for Oracle released.

Пресса: EMS SQL Manager for Oracle


EMS SQL Manager for Oracle version 3.2 released

We are pleased to announce the new major 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 3.2?

  1. Support of new Oracle 12c feature: Use of sequences in fields editor. Support of autoincrement fields.
  2. Support of new Oracle 12c feature: DEFAULT ON NULL option of column editors.
  3. Support of new Oracle 12c feature: Size of varсhar type fields is up to 32767 bytes.
  4. Support of new Oracle 12c feature: PL/SQL subprograms in WITH … SELECT queries.
  5. Support of new Oracle 12c feature: Partitioning mechanism is improved:
    • Online move of partitions (without demounting database);
    • Delete and remove several partitions at once;
    • Split and merge partitions.
  6. Support of new Oracle 12c feature: Granting and revoking program module roles.
  7. Support of new Oracle 12c feature: Support of limits when uploading table and view data.
  8. Support of new Oracle 12c feature: Support of KEEP … SESSION option in sequences.
  9. Extract Database. Option "Delete existing records" is added.
  10. Role editor. Support of IDENTIFIED USING option.
  11. HTML Report. Operating procedure is significantly improved; HTML reports are created much faster now.
  12. When connecting through SSH, if SID and alias in tnsnames.ora were different, the connection error ORA-12514 occurred. Fixed now.
  13. When saving the diagram of Visual Database Designer as image, it was cut. Fixed now.
  14. Despite the restrictions set in "Schema Restriction" the whole range of schemas was requested from the server. Fixed now.
  15. When opening large tables the query interruption occurred with the4 second time-out, despite the time-out settings. Fixed now.
  16. Lots of other improvements and bug-fixes.

We hope you’ll enjoy working with our products

Source: http://www.sqlmanager.net/en/products/oracle/manager/news/1961