Skip Headers
Oracle® TimesTen In-Memory Database Reference
Release 11.2.1

Part Number E13069-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF



Destroys a data store including all checkpoint files, transaction logs and daemon catalog entries (though not the DSNs).

Required privilege

This utility requires the instance administrator privilege.


ttDestroy {-h | -help | -?}
ttDestroy {-V | -version}
ttDestroy [[-wait] [-timeout secs]] [-force] {-connStr connection_string | DSN | dspath}


ttDestroy has the options:

Option Description
-connStr connection_string An ODBC connection string containing the name of the data store, the server name and DSN (if necessary) and any relevant connection attributes.
DSN Specifies an ODBC data source name of the data store to be destroyed.
dspath The fully qualified name of the data store to be destroyed.

This is not the DSN associated with the connection but the fully qualified data store path name associated with the data store as specified in the DataStore= parameter of the data store's ODBC definition.

For example, for a data store consisting of files/home/payroll/1997.ds0, /home/payroll/1997.ds1, and several transaction log files /home/payroll/1997.logn,dspath is /home/payroll/1997.




Prints a usage message and exits.
-force Destroy even if files are from an incompatible version or a different instance of TimesTen.
-timeout seconds Indicates the time in seconds that ttDestroy should wait. If no timeout value is supplied, TimesTen waits five seconds before retrying the destroy operation.
-V | -version Prints the release number of ttDestroy and exits.
-wait Causes ttDestroy to continually retry the destroy operation until it is successful, in those situations where the destroy fails due to some temporary condition, such as when the data store is in use.


ttDestroy /users/pat/TimesTen/Daily/F112697


Using ttDestroy is the only way to delete a data store completely and safely. Do not remove data store checkpoint or transaction log files manually.

This utility is supported only where the TimesTen Data Manager is installed.

In the case that the data store to be destroyed is part of a cache grid, ttDestroy performs a detaches the data store from the grid.

ttDestroy does not perform cleanup of Oracle objects from AUTOREFRESH or AWT cache groups. If there are AUTOREFRESH or AWT cache groups in the data store, use the ttCacheSqlGet built-in procedure, specifying NULL for the cache group name, to generate Oracle SQL to perform cleanup after the data store has been destroyed.