Online Documentation for SQL Manager for Oracle
Please read this page attentively if you have questions about EMS SQL Manager for Oracle.
- What is EMS SQL Manager for Oracle?
- What is the difference between Full and Lite versions of EMS SQL Manager for Oracle?
- What do I need to start working with EMS SQL Manager for Oracle?
- What is the difference between the Export/Import functions in SQL Manager and the Data Export/Import utilities?
- What is the difference between the Design Query module in SQL Manager and the SQL Query for Oracle standalone utility?
- What is the difference between the Extract Database function in SQL Manager for Oracle and the DB Extract for Oracle standalone utility?
- I can't modify DDL. Why?
- I can't configure connection to Oracle server via SSH. Which values do I need to input in the SSH section of the Database Registration Info dialog?
- When I create database objects, their names are always converted to upper case. How I can prevent it?
- How can I create a report?
- How can I customize data formats in grid?
- I need to perform some changes in database objects of my test database and then make the same changes on another database. Are there any tools for this purpose in SQL Manager for Oracle?
- How can I speed up my work with large tables?
- I am trying to export a table, but text fields are not exported.
- What is the difference between the "Extract Database" and "Export as SQL Script" functions?
- How can I change the default directory where exported data will be saved?
A: EMS SQL Manager for Oracle is a powerful tool for Oracle Database administration and development. SQL Manager for Oracle supports all of the latest Oracle features. It offers plenty of powerful tools for experienced users to satisfy all their needs. SQL Manager for Oracle has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.
A: These editions of SQL Manager for Oracle differ in price and features. To register SQL Manager for Oracle, see the Purchase page, and to learn about the difference in features please go to our Feature Matrix page.
A: First of all, you must have an opportunity to connect to some instance of Oracle server to work with SQL Manager. Besides, you need your workstation to satisfy the system requirements of SQL Manager for Oracle.
A: The Data Export/Import for Oracle utilities include some additional features which are not available in SQL Manager, such as:
- export/import data from/to several tables simultaneously;
- a command-line utility to export/import data using the configuration file with all the export/import options.
A: First of all, SQL Query for Oracle works faster, as it is a much lighter product. Besides, it provides additional features for query building, e.g.
- keeping query history which allows you to rollback to any edited query;
- various interface improvements for more productive and easier work.
A: The DB Extract for Oracle utility includes some additional features which are not available in SQL Manager, such as:
- a console application for performing extract in one-touch;
- faster extraction speed.
A: The DDL tab of the SQL Manager editors is read-only. It displays object structure as SQL text and reflects the operations you perform over the object under other editor tabs. To modify an object, you can copy the text to the clipboard and edit it using Query data. For more details refer to Viewing object DDL structure.
A: To setup the connection via SSH tunnel, you need to input the following:
within the SSH Tunneling section:
- SSH host name is the name of the host where SSH server is running
- SSH port indicates the port where SSH server is activated
- SSH user name stands for the user on the machine where SSH server is running
- SSH password is the Linux/Windows user password
within the Connection section:
- User name is an Oracle user name
- Password is password for Oracle user
For more details refer to SSH tunneling options.
A: To create a report, you can use the Create Report wizard or Report Designer. To create a simple report based on a query, you need to select "Master Data band" on the Selecting report bands step of the wizard and specify the query for your report. After that you need to set the remaining options on subsequent steps of the wizard and press Run.
A: For your convenience and to speed up your work, the Data Grid allows customizing a number of data display parameters. Here are the most important of them (accessible through the Grid | Data Options section of the Environment Options dialog):
- Limit options in table and view editors. The 'Select all records of a table' option will enable you to see all table records without extra references to the server, yet in case of large tables or low speed connection channel the data may be fetched with huge delays and the incoming traffic might grow considerably. This mode is recommended when working with local databases or in a private network. The 'Select only' mode restricts the maximum number of records returned after the query. A man cannot process a massive amount of information at once. Hence, we came up with this mode. This mode speeds up table data viewing considerably, prevents hanging and connection timeout. It is recommended to work with large tables, in case of low speed connection channels and when the traffic volume is of importance. This is the default mode. When in this mode, enabling the 'Use SQL sorting in data view' and 'Use SQL filter in data view' options comes really helpful.
- Default Grid Mode. This option defines whether the requested rows will be loaded in the Grid all at once ('Load all rows'), or in parts ('Load visible rows') as the user scrolls down table data. The first mode increases the query opening time, but speeds up scrolling. In the second mode the query opens very fast, but there might be delays when navigating the grid.
We recommend that you set the following option values to achieve maximum efficiency when working with large tables:
- Select only – ON
- Load visible rows – ON
A: Fields of types BLOB, CLOB, NCLOB, BFILE, LONG, LONG ROW and XML are not exported by default. You should select these fields manually at the Selecting fields for export step.
A: Export as SQL Script is intended for exporting table data that will be inserted into a database system other than Oracle Database. Use Extract Database Wizard to copy metadata and/or data to a database on Oracle afterwards.
A: Follow the steps below to change the default directory:
1. Right-click the database alias in DB Explorer and select the 'Database Registration Info...' context menu item (you can also find this item in the 'Database' main menu) to open the Database Registration Info dialog.
2. Proceed to the Directories section within the dialog.
3. Set the 'Default directory for Export Data'.
If you still have any questions, contact us at our Support Center.