SQL Administration

TimesTen provides SQL statements for administrative activities such as creating and managing tables, indexes, views, materialized views, synonyms, sequences, users, privileges and cache groups. TimesTen provides SQL statements for creating and managing replication schemes.

Administrators can run SQL statements within the ttIsql utility. For example, there are several built-in ttIsql commands that display information on database structures. For a complete list of SQL statements, see SQL Statements in the Oracle TimesTen In-Memory Database SQL Reference.

TimesTen stores metadata (information about the contents of your database) in system tables in your database. TimesTen also provides system views that enable you to use SQL to query information.

In addition, TimesTen provides several local (V$) system views you can query to retrieve metadata information about your TimesTen database. See System Tables and Views in the Oracle TimesTen In-Memory Database System Tables and Views Reference.