Wednesday, May 23, 2007

Oracle:Global Temporary Table and ORA-14450

"Distributed transactions are not supported for temporary tables".

if some DML operations are performed on a global temporary table and then if we try and read the temporary table from some procedure in an autonomous transaction, then we encounter the error since table is locked by the main transaction.

This error you get while there is no COMMIT/ROLLBACK yet done and if you are trying to perform some DDL(Like Alter or Drop) on the GT table.

In cases where the GT table is created with option "on commit preserve rows", the table remains locked even after COMMIT.

No comments: