Object Browser Filter Tree

The filter count and filtering status of the tree are not supported.

Character Encoding

When viewing SQL, DDL, object names or data containing Chinese characters, Data Studio encoding needs to be set to GBK provided OS supports GBK. For more information on changing encoding settings, refer to Environment > Session Setting.

Connection Management

Commas are considered as delimiter in Include/Exclude fields in Advanced tab of add and edit connection window. Hence, a schema name with commas is not supported in Include/Exclude fields.

Database Tables

• In the Index tab of the Create Table wizard, the original order cannot be maintained after the selected columns are deleted in the colum view.
• When an operation has completed, and if the Data Studio window is not the active window of the operating system, then the message dialog is shown only when the Data Studio window becomes active.
• The following limitations are applicable to Edit Table Data operations:
  • Entering expression values in the Edit Table Data tab is not supported.
  • Data Studio allows editing of fetched records only.
  • The Editing table filter feature will not highlight search words within HTML tags such as <, &, >.
  • A cell containing single '&' in it will not be displayed in the tooltip. A cell containing two consecutive '&' will display as a single '&' in the tooltip.
  • Row focus is not retained on a newly added row. User must click on the desired cell to start editing.

Function/Procedure

Functions/Procedures created in the SQL Terminal or the Create Function/Procedure wizard must end with "/" to indicate the end of functions/procedures. Statements entered after a function/procedure without "/" at the end will be treated as a single query and may trigger errors during execution.

General

• A maximum of 100 tabs can be opened in the editor area. Tabs are based on available resources of the host machine.
• A maximum of 64 characters (text only) are allowed for database object names (database, schema, function, procedure, table, sequence, constraint, index, view, and tablespace). There is no limit to the number of characters that can be used in expressions and descriptions in Data Studio.
• A maximum of 300 result tabs can be opened on a logged instance of Data Studio.
• If there are large objects loaded in Object Browser and Search Object window, expanding of objects in Object Browser may be slow and Data Studio may become unresponsive.
• Resizing the width of a cell containing data exceeding the available display area may cause DS to become unresponsive.
• When the data in a table cell is more than 1000 characters, it will be trimmed to 1000 characters with "..." at the end.
  • If the user copies the data from a cell in a table or the Result tab and pastes it on any editor (such as SQL terminal/PLSQL source editor, notepad or any other external editor application), the entire data is pasted.
  • If the user copies the data from a cell in a table or the Result tab and pastes it on an editable cell (same or different), the cell shows only the first 1000 characters with "..." in the end.
  • When the table/Result tab data is exported, the exported file contains the whole data.

Security

Data Studio validates SSL connection parameters only for the first connection profile. If a second connection is opened, the connection uses the same SSL connection parameters when the Enable SSL field is checked.

For SSL connection, if security files are corrupted, DS will not be able to proceed with any database operations. To recover from this, please remove security folder under the corresponding profile folder and restart DS.

SQL Terminal

• Opening an SQL file containing a large number of queries may result in an 'Insufficient Memory' error. For more information, refer to Troubleshooting.
• Data Studio does not disable the auto-suggest and hyperlink features in the commented text in the SQL Terminal.