On, Off

Off

Can be set for an individual connection or for PUBLIC. You must have the SET ANY SYSTEM OPTION system privilege to set this option for PUBLIC or for another user or role. Takes effect immediately.

When this option is set to On, the database server executes a COMMIT before an index is created on a local temporary table. If the commit fails, the operation fails or rolls back. When this option is set to Off (the default), a COMMIT is not performed, which allows a procedure that relies on the index to be used as part of an atomic operation (such as a trigger, UPDATE statement, INSERT statement, DELETE statement, or the FROM clause).

• CREATE INDEX statement