EMS SQL Manager Lite for Oracle Publisher's description
A high performance tool for Oracle Database Server administration and development
EMS SQL Manager Lite for Oracle is a high performance tool for Oracle Database Server administration and development. EMS SQL Manager Lite for Oracle works with any Oracle versions from 8.1.7 to 10g and supports all Oracle objects and all Oracle data types including the new BINARY_FLOAT and BINARY_DOUBLE types, and others.
EMS SQL Manager for Oracle offers plenty of powerful tools for experienced users such as Visual Database Designer, Visual Query Builder, and powerful BLOB editor to satisfy all their needs. SQL Manager for Oracle has a state-of-the-art graphical user interface with a well-described wizard system, so clear in use that even a newbie will not be confused with it.
Here are some key features of "EMS SQL Manager Lite for Oracle":
В· New state-of-the-art graphical user interface
В· Office 11 and Windows XP visual schemes support
В· Well-described Wizard System
В· User-friendly database explorer for easy management of all Oracle objects
В· Windows Toolbar to switch between windows easily, like in Windows Task Bar
В· Navigation bars with hot actions in most of the windows
В· Ability to save all program settings
В· Customizable toolbars for all program windows
В· Fully customizable program interface
В· Powerful visual options module
В· Localizable program interface
В· Easy management of all Oracle objects (including create/edit/ drop operations)
В· Managing tables and all their subobjects: fields, primary, unique and foreign keys, indices, triggers, and check constraints
В· Managing views and all their subobjects: fields, triggers, primary, unique and foreign keys
В· Managing procedures, functions, sequences, packages and package bodies
В· Managing users, roles, profiles, consumer groups and resource plans
В· Managing database and schema triggers, clusters, synonyms, database links, materialized views and materialized view logs
В· Managing object and array types, object type bodies, libraries
В· Managing java sources, resources and classes
В· Managing index types, operators, dimensions
В· Managing contexts, directories, table spaces, rollback segments, redo log groups
В· Duplicating database objects
В· Viewing dependencies between database objects
В· Rapid database management and navigation
В· Multiple host/database connections
В· Registering selected databases to work with
В· Schema restriction to see only required schemas
В· Projects to work with the selected database objects only
В· Multiple user-defined tabs for any tree node to access it in one-click
В· Working with multiple selected objects at a time
В· Grouping/Ungrouping registered databases
В· Advanced data manipulation tools
В· Plenty of useful tools such as data grouping, fast search and filtering
В· Effective security management
В· Grant manager displaying all database object grants in the form of a grid
В· Ability to set permissions for table columns
В· Easy management of database users, roles and profiles
В· Excellent visual and text tools for query building
В· Multiple SQL editors with code completion and syntax highlight
В· Large script execution (SQL script editor)
В· Latest Oracle version support
В· Support of all server versions from 8.1.7 to 10g R2
В· Support of all Oracle data types including the new BINARY_FLOAT and BINARY_DOUBLE types
В· Powerful and easy management of object permissions, including column-level permissions
В· And other useful features
В· Keyboard templates
В· External tool manager
В· To-do list
В· Other useful tools to make your work with Oracle server as easy as it can be
В· Extracting metadata into text files or SQL script editor
В· SQL Monitor
What's New in This Release:
В· New events for monitoring are added.
В· It is now possible to view the description for each alert and the objects which the alert refers to.
Oracle client check:
В· The algorithm of Oracle homes searching is changed (e.g. INSTANT_CLIENT and XE_CLIENTS are supported now).
В· The errors are now displayed with the fixing instructions.
В· Dependency Tree. The mechanism of the dependency tree building is improved; the building speed is increased.
В· Added the possibility to enable/disable triggers in the object context menu in the DB Explorer.
В· Register Database wizard. The new item is added to the вЂњConnect UsingвЂќ list which indicates that the connection will be performed through TNS_ADMIN.
В· The вЂњQuote low case identifiersвЂќ option is added.
В· Added the вЂњAutocreation optionsвЂќ option which automatically creates synonyms when creating a new object.
В· Field Editor. Added the possibility to imitate an auto increment field by creating a correspondi...
В· 300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
В· 64 MB RAM (128 MB or above is recommended)
В· 50MB of available HD space for program installation
В· Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended
В· Microsoft Mouse or compatible pointing device
В· Oracle Client 8.1.7 or higher
В· Possibility to connect to any local or remote Oracle server
Program Release Status:
Program Install Support: Install And Uninstall