This tutorial provides a step-by-step guide on how to set up and create a TimesTen database. You need to be the user that installed TimesTen to create a database. This user is known as the instance administrator.
1. Setting up a Data Source Name (DSN)
-How to set up a DSN on Linux / UNIX -How to set up a DSN on Windows
2. Creating a TimesTen Database
A TimesTen database is simply created by connecting to it. A first connection to an already-existing database results in loading the database in memory. Database objects can be created once a connection has been established to the database. Only the instance administrator can create a TimesTen database.
As an example, let us use ttIsql to create and connect to the database my_ttdb.
a. The main TimesTen daemon process or the TimesTen Windows service must be running before you can create a database. Only the instance administrator is authorized to start the daemon. The utility ttDaemonAdmin is used to start the daemon. Enter ttdaemonadmin -start on the OS command line to start the daemon, if it has not been started. ttdaemonadmin -start Note. ttdaemonadmin and other TimesTen database utilities are located in the install_dir/bin directory. To make these utilities readily available, include the bin directory in the PATH environment variable, or run the ttenv script to set up your TimesTen environment. Refer to the section "Environment variables" in the Oracle TimesTen In-Memory Database Installation Guide for more information. b. Enter ttisql at the OS command prompt to launch ttIsql. ttisql c. Enter connect "dsn=my_ttdb"; at the ttIsql command prompt . d. When the connect command returns, the database my_ttdb has been created and loaded into memory.
Home | Site Map | Contact Us | Copyright © 2011 |