1. SQL Developer Support User's Guide
  2. What's New

What's New

This section summarizes the new features of TimesTen In-Memory Database supported in Oracle SQL Developer Release 21.2. There are some features that are only supported in TimesTen Scaleout. If a feature is only supported in TimesTen Scaleout, it will be noted.

Note:

In this document:

  • 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).

New features for release of SQL Developer 21.2

Features supported in TimesTen Scaleout Release 22.1 or higher:

  • You can create a grid in TimesTen Scaleout with a K-safety level up to 5.

New features for release of SQL Developer 20.4

Features supported in TimesTen Release 18.1.4.1.0 or higher:

  • You can create, edit, or drop password management profiles for database users in TimesTen databases. See Working with profiles.

  • The Create User and Edit User dialogs are enabled to:

    • Assign an existing profile to the user.

    • Lock the user account.

    • Expire the password.

  • You can reset the password of the database user used for the TimesTen connection. See Reset password of connected user.

New features for release of SQL Developer 19.1

Features supported in TimesTen Scaleout Release 18.1.2.1 or higher:

  • For stop or unload database operations, you can opt to force all user connections to disconnect if the initial attempt to terminate such connections fails.

Features supported in TimesTen Scaleout Release 18.1.1.3 or higher:

  • The Connection Details dialog now displays information on the element, host, instance, connection name, process id, and type of connection for the selected connection.

New features for release of SQL Developer 18.2

  • You can alter a table that is already created. See Edit a table for more information.

Features supported in TimesTen Release 18.1 or higher: