Oracle Maestro 7.5 released

May 7, 2007

SQL Maestro Group is happy to announce the release of Oracle Maestro 7.5, a powerful Windows GUI solution for Oracle database server administration and development.

Please consider the list of new features implemented in Oracle Maestro 7.5 since last official release:

Server management extensions:

• Session Browser is implemented. This feature is very useful for DBAs who want to monitor the users' activity (in fact, there are potentially thousands of sessions in a database at any one time). You can view details for each session (such as login, connect time, database name, client host, last SQL statement executed and more) as well as group and filter sessions by client host, connected user, database, client application, etc.
  To access the Session Browser window, select the corresponding item from the Tools menu.
  
  
• Another important thing implemented in this version of Oracle Maestro is the Database Export feature, which represents a GUI wrapper for standard EXP utility. This tool allows you to choose export mode (database, schemas, tablespaces or tables), select objects to export and specify a lot of additional options to get the database dump according to your needs. It is also possible to save all the settings as a batch file for future executing.
  This window also can be invoked from the Tools menu. Please note that you should have installed the EXP utility to use this functionality.
  
  
• Now Oracle Maestro uses the TRUNCATE statement for table emptying (instead of DELETE one).
  
  
• Fixed the bug with importing data to CLOB fields.
  
  

• Database Designer: a possibility of locking/unlocking diagram objects is added. This feature prevents your diagram from unforeseen changes: when the diagram is locked, you can neither move/resize/delete existing objects nor add new ones.
  
  
• Some new features are incorporated into SQL Editor and SQL Script Editor. Now it is possible:
  
  
  • comment/uncomment selected text (Shift+Ctrl+. / Shift+Ctrl+, shortcuts respectively). If no text is selected, the whole line will be commented. By the way, it is not necessary to select commented text to uncomment it, just press Shift+Ctrl+, having the cursor inside the commented text. Both kinds of comments (single-line and multi-line) are supported;
    
    
  • convert selected text to different cases (lower, UPPER, and NameCase);
    
    
  • export the contents of the editor to RTF and HTML formats (to file or to clipboard);
    
    
  • print/preview the contents of the editor.
    
    
• The Copy to SQL Script Editor command is added to all object editors (available in the Navigation Bar on the SQL tab). Use it for quick copying object’s SQL definition (DDL) to the SQL Script Editor for future modifications;
  
  
• Explorer tree: the Browse command is added to lists' popup menus (runs the Object Browser tool).
  
  

In addition to this, several bugs were fixed and some other minor improvements and corrections were made.

Related links:

Back to news archive