1/14
Contents
Title and Copyright Information
Preface
Audience
Related documents
Conventions
Documentation Accessibility
Technical support
What's New
New features for release of SQL Developer 3.1
1
Connecting to a TimesTen Database
Setting environment variables for TimesTen and SQL Developer
Defining a TimesTen database named connection
Using an existing TimesTen database named connection
Disconnecting an existing TimesTen database connection
2
Prerequisites to Creating and Accessing a Cache Environment
Configuring the Oracle and TimesTen databases
Set the cache administration user name and password
Configure a cache grid
Start and stop the cache agent
3
Creating Cache Groups
Creating a cache group
Defining a cache group and cache table attributes
Defining the root table
Selecting the columns to cache
Specifying the table attributes
Specifying an aging policy
Verifying the root table definition
Defining the child tables
Selecting the columns to cache
Specifying the table attributes
Completing the definitions of the child tables
Verifying the cache group definition
Dropping a cache group
4
Cache Group Operations
Loading or refreshing a cache group
Unloading a cache group
Flushing a cache group
5
Cache Group and Cache Table Characteristics
Viewing the characteristics of a cache group
Viewing the cache tables
Viewing the cache group definition
Viewing the aging attributes
Altering the automatic refresh attributes of a cache group
6
Working with TimesTen Objects
Locating a TimesTen database object
Specifying and displaying LOB data types
Specifying the INLINE attribute for columns
Computing table size information
Using a REF CURSOR as an OUT parameter
Viewing the characteristics of a table
Viewing the columns
Viewing the indexes
Viewing the aging attributes
Viewing the table definition
Creating an index on a table
Creating a primary key constraint
Changing the attributes of primary key
Altering the aging properties of a table
Adding an aging policy to a table
Dropping an aging policy from a table
Changing the aging state of a table's aging policy
Changing the memory usage thresholds and LRU aging cycle
Changing the lifetime and cycle of a table's time-based aging policy
Granting and revoking object privileges
Viewing the privileges granted on a database object
Loading data into tables
ttIsql commands in SQL worksheet
7
Interfacing with TimesTen Replication
Viewing the replication scheme
Viewing the details of the TimesTen subscriber databases
Viewing the store attributes of the replicated TimesTen databases
Starting the replication agent
8
Interfacing with the TimesTen Query Optimizer
Updating the table and column statistics used by the query optimizer
Viewing the execution plan of a statement
9
TimesTen Reports
Generating TimesTen Reports
About Your Database
All Objects
Cache Groups
Database Administration
PLSQL
Security
Table
Index
Scripting on this page enhances content navigation, but does not change the content in any way.