|Oracle® TimesTen In-Memory Database SQL Reference
Part Number E13070-07
This section lists new features for Release 11.2.1 that are documented in this reference and provides cross-references to additional information.
This section lists new features for Release 184.108.40.206.0 that are documented in this reference and provides cross-references to additional information:
The system tables and replication tables are now documented in Oracle TimesTen In-Memory Database System Tables and Limits Reference.
You can modify the REPLICATION_TRACK session parameter for parallel replication with the ALTER SESSION statement. See ALTER SESSION for more details.
This section lists new features for Release 220.127.116.11.0 that are documented in this reference and provides cross-references to additional information:
You can create synonyms for database objects including tables, views, synonyms, sequences, PL/SQL stored procedures, PL/SQL functions, PL/SQL packages, materialized views and cache groups. For more information, see:
If privileges on a table owned by one user are revoked from another user, the associated materialized views owned by the second user are marked invalid. See "Invalid materialized views".
This section lists new features for Release 18.104.22.168.0 that are documented in this reference and provides cross-references to additional information.
Revised reserved words. See Chapter 7, "Reserved Words".
The ALTER SESSION statement has been enhanced.
These statements are new:
These SQL functions are new:
These IMDB Cache features are new:
Dynamic cache groups - In a dynamic cache group, new cache instances are loaded manually into the TimesTen cache tables using a load operation, or on demand using a dynamic load operation. See:
Cache grid - A cache grid is a collection of TimesTen databases that collectively manage the application data using the relational data model. A cache grid consists of one or more grid members each backed by a TimesTen database. See "CREATE CACHE GROUP".
Global cache groups - In a global cache group, data in the cache tables are shared among TimesTen databases within a cache grid. See "CREATE CACHE GROUP".
Materialized views can be refreshed asynchronously. The CREATE MATERIALIZED VIEW statement has been enhanced. These statements are new:
The ROWID data type has been implemented. See "ROWID data type".
TimesTen offers Oracle-style behavior for duplicated parameter names. See "Duplicate parameter names".
You can create bitmap indexes. See "CREATE INDEX".
Set operators are allowed in subqueries. See "Subqueries".
":" parameter markers have been enhanced. See "Dynamic parameters".
You can use multiline C-style comments in SQL statements. See "Comments within SQL statements".