Why does I have to commit after the creation of an index?

[Roeland]

Hi,

When creating a Oracle Text index in a SQL Window, the icon for "Commit" and "Rollback" is enabled. I think this is a bug. The creation of an index is automatically committed.

Roeland

PLSQL Developer 8.0.4.1514
Oracle 10.2.0.4
Oracle Client 11.2

 

[Marco Kalter]

It is not a PL/SQL Developer bug though. There is an open transaction after performing this action.

 

[Thoreau]

Actually, Oracle performs an implicit commit after any SQL DDL (Data Definition Language) statement (even if this DDL statement fails).

This includes table / index creation. So no open transaction should exist.

 

[Marco Kalter]

And yet there is an open transaction. You can verify by using the sys.dbms_transaction.local_transaction_id function.