Oracle® TimesTen In-Memory Database SQL Reference Release 11.2.1 Part Number E13070-04 |
|
|
View PDF |
This section lists new features for Release 11.2.1 that are documented in this reference and provides cross-references to additional information.
These features are new in Release 11.2.1.4.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:
CREATE ANY SYNONYM, CREATE PUBLIC SYNONYM, DROP ANY SYNONYM and DROP PUBLIC SYNONYM system privileges in Table 6-1, "System privileges"
SYS.ALL_SYNONYMS, SYS.DBA_SYNONYMS and SYS.USER_SYNONYMS system views
The SYS.SYSTEMSTATS system table stores system-wide monitoring statistics.
Time-based aging can now be specified for tables and cache groups in units of seconds as well as minutes, hours, and days. See the ALTER TABLE, CREATE TABLE, and CREATE CACHE GROUP statements.
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 11.2.1.1.0 that are documented in this reference and provides cross-references to additional information.
New system privileges and object privileges. See Chapter 6, "Privileges". Also see "Required privileges" for each SQL statement in Chapter 5, "SQL Statements".
New system views:
New syntax for ALTER USER, CREATE USER, DROP USER, GRANT and REVOKE statements
Revised reserved words. See Chapter 8, "Reserved Words".
The ALTER SESSION statement has been enhanced.
These statements are new:
These system tables and system views are new:
SYS.ALL_ARGUMENTS, SYS.DBA_ARGUMENTS and SYS.USER_ARGUMENTS
SYS.ALL_DEPENDENCIES, SYS.DBA_DEPENDENCIES and SYS.USER_DEPENDENCIES
SYS.ALL_ERRORS, SYS.DBA_ERRORS and SYS.USER_ERRORS
SYS.ALL_IDENTIFIERS, SYS.DBA_IDENTIFIERS and SYS.USER_IDENTIFIERS
SYS.ALL_OBJECTS, SYS.DBA_OBJECTS and SYS.USER_OBJECTS
SYS.ALL_PLSQL_OBJECT_SETTINGS, SYS.DBA_PLSQL_OBJECT_SETTINGS and SYS.USER_PLSQL_OBJECT_SETTINGS
SYS.ALL_PROCEDURES, SYS.DBA_PROCEDURES and SYS.USER_PROCEDURES
SYS.ALL_SOURCE, SYS.DBA_SOURCE and SYS.USER_SOURCE
SYS.ALL_STORED_SETTINGS, SYS.DBA_STORED_SETTINGS and SYS.USER_STORED_SETTINGS
SYS.DBA_OBJECT_SIZE and SYS.USER_OBJECT_SIZE
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 DELETE, INSERT and UPDATE statements have been enhanced with the RETURNING...INTO clause.
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".
A view and a sequence cannot have the same name. See "CREATE VIEW" and "CREATE SEQUENCE".