Oracle TimesTen In-Memory Database Documentation
Release 22.1

1. Install TimesTen

• Create an installation
• Create an instance
• Configure operating system parameters
• Source environment variables

2. Create a TimesTen Database

• Create a Data Source Name (DSN)
• Create and connect to the database
• Load a database into memory

3. Set Up and Use Your Database

• Create profiles (optional)
• Create users
• Grant privileges
• Create objects
• Load data
• Perform SQL operations

Manage Your Database

• Open and close a database
• Load and unload a database from memory
• Use TimesTen system views
• Use TimesTen utilities
• Use TimesTen built-in procedures
• Back up and restore a database
• Destroy a database

Manage a TimeTen Instance

• Start and stop the TimesTen daemon
• Monitor the TimesTen daemon
• Modify a TimesTen instance

Set Up Replication to Provide High Availability

• Configure an active standby replication pair
• Monitor the replication agent
• Monitor the replication transmission

Use Client/Server

• Install and configure client/server
• Define server DSNs
• Define client DSNs
• Test connections

Migrate and Upgrade

• Migrate your database
• Upgrade your server instance
• Upgrade your client instance
• Perform an online upgrade using active standby pair