TimesTen DDL Commit Behavior

The TimesTen database issues an implicit COMMIT before and after any DDL statement. A durable commit is performed after the processing of each DDL statement. This behavior is the same as the Oracle database.

DDL statements include the following:

• CREATE, ALTER and DROP statements for any database object, including tables, views, users, procedures and indexes.

• TRUNCATE

• GRANT and REVOKE

There are certain things to keep into consideration:

• DDL changes cannot be rolled back.

• DDL statements delete records from global temporary tables unless the tables were created with the ON COMMIT PRESERVE ROWS clause.

• Tables created with the CREATE TABLE . . . AS SELECT statement are visible immediately.

• TRUNCATE statements are committed automatically. However, the truncate of the parent and child tables must be truncated in separate transactions, with the child table truncated first. You cannot truncate a parent table unless the child table is empty.