Oracle SQL Developer is a graphical user interface (GUI) tool that gives database developers a convenient way to perform basic tasks. You can browse, create, edit and drop particular database objects; run SQL statements and scripts; manipulate and export data; and view and create reports. This guide is a supplement to the Oracle SQL Developer User's Guide for TimesTen In-Memory Database specific features.
Oracle TimesTen In-Memory Database (TimesTen) is a relational database that is memory-optimized for fast response and throughput. The database resides entirely in memory at runtime and is persisted to disk storage.
Oracle TimesTen In-Memory Database in classic mode, or TimesTen Classic, refers to single-instance and replicated databases (as in previous releases).
Oracle TimesTen In-Memory Database in grid mode, or TimesTen Scaleout, refers to multiple-instance distributed databases. TimesTen Scaleout is a grid of interconnected hosts running instances that work together to provide fast access, fault tolerance, and high availability for in-memory data. A grid contains one or more databases and each database is distributed across all instances of the grid.
TimesTen alone refers to both classic and grid modes (such as in references to TimesTen utilities, releases, distributions, installations, actions taken by the database, and functionality within the database).
TimesTen Application-Tier Database Cache, or TimesTen Cache, is an Oracle Database Enterprise Edition option. TimesTen Cache is ideal for caching performance-critical subsets of an Oracle database into cache tables within TimesTen databases for improved response time in the application tier. Cache tables can be read-only or updatable. Applications read and update the cache tables using standard Structured Query Language (SQL) while data synchronization between the TimesTen database and the Oracle database is performed automatically. TimesTen Cache offers all of the functionality and performance of TimesTen Classic, plus the additional functionality for caching Oracle Database tables.
TimesTen Replication features, available with TimesTen Classic or TimesTen Cache, enable high availability.
You can use Oracle SQL Developer to connect to a target TimesTen database and perform operations on particular objects in the database.
This guide describes the various tasks that you can perform with SQL Developer for TimesTen databases. However, TimesTen Scaleout supports and includes most of the features of TimesTen Classic database; it does not support any of the features of the TimesTen Application-Tier Database Cache. For more information on what features are not supported in TimesTen Scaleout, see "Comparison between TimesTen Scaleout and TimesTen Classic" in the Oracle TimesTen In-Memory Database Scaleout User's Guide.
This guide is intended for those who use the Oracle SQL Developer tool with TimesTen In-Memory Database, TimesTen Application-Tier Database Cache, or TimesTen Replication. Application developers and system administrators can use SQL Developer to create and manage cache groups, and other database objects.
TimesTen documentation is available at https://docs.oracle.com/database/timesten-18.1 and on the Oracle Technology Network:
http://www.oracle.com/technetwork/database/database-technologies/timesten/documentation/index.html
Oracle Database documentation is also available on the Oracle documentation website. This may be especially useful for Oracle Database features that TimesTen supports but does not attempt to fully document, such as OCI and Pro*C/C++.
The SQL Developer software download is available on Oracle Technology Network (OTN) at:
http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html
TimesTen supports multiple platforms. Unless otherwise indicated, the information in this guide applies to all supported platforms. The term Windows refers to all supported Windows platforms. The term UNIX applies to all supported UNIX platforms. The term Linux is used separately. See "Platforms" in Oracle TimesTen In-Memory Database Release Notes for specific platform versions supported by TimesTen.
The following text conventions are used in this document:
| Convention | Meaning |
|---|---|
| boldface | Boldface type indicates graphical user interface elements associated with an action, or terms defined in text. |
| italic | Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values. |
monospace |
Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter. |
In addition, TimesTen documentation uses the following special conventions:
| Convention | Meaning |
|---|---|
installation_dir |
The path that represents the directory where TimesTen is installed. |
timesten_home |
The path that represents the home directory of a TimesTen instance. |
release or rr |
The first three parts in a release number with or without dots. The first three parts of a release number represent a major TimesTen release. For example, 181 or 18.1 represents TimesTen 12c Release 12.1.1. |
jdk_ver |
One or two digits that represent the version number of a major JDK release. For example, 14 is for JDK 1.4 and 5 is for JDK 5.0. |
DSN |
TimesTen data source name (for the TimesTen database). |
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.