Oracle SQL Developer 3.1 - TimesTen Features List

 
SQL Developer 3.1 provides the following TimesTen In-Memory Database and In-Memory Database Cache (TimesTen) features:
 
General
 
  • Support concurrent connections to TimesTen database and Oracle Database
  • Support Oracle TimesTen and In-Memory Database Cache 11g Release 1 and Release 2
  • Available on Linux and Windows platforms
 
Database Objects
 
  • Create and drop users, change user password, grant, revoke and view system and object privileges
  • Browse, create, and edit TimesTen database objects including tables, views, indexes, sequences, synonyms, materialized views, materialized view logs, PL/SQL packages, procedures and functions
  • Filter and narrow the list of objects displayed while browsing database schema
  • Define and alter data aging policies on tables
  • Support a number of data types including LOB (large object) data types
  • Query, update and delete data in regular and cache tables
  • Export data from Oracle and TimesTen tables in ttBulkCp format, and import data to TimesTen tables
  • Compute table size, update and view table and column statistics
 
Cache Group
 
  • Create and drop cache groups
  • Perform cache group operations, such as Load, Refresh, Unload and Flush
  • Alter autorefresh intervals, status and aging properties of cache groups
 
PL/SQL, Worksheet and Reports
 
  • Create, edit, compile and run PL/SQL packages, procedures and functions
  • Execute TimesTen built-in procedures and selected ttIsql commands in SQL Worksheet
  • View SQL execution plans from SQL Worksheet
  • Run pre-defined reports on TimesTen database objects including cache groups
  • Create and run user-defined reports