I get this error when 'BEFORE DROP TABLE' trigger is fired.

ORA-14540: An Online DDL or a DDL with the UPDATE INDEXES clause cannot be used with auto-commit turned off for the DDL

The trigger performs data movement to a different tablespace.

Data movement method used:

ALTER TABLE table_name MOVE ONLINE ROW STORE COMPRESS ADVANCED NOPARALLEL TABLESPACE new_tbs UPDATE INDEXES (index_name TABLESPACE new_tbs);

I am not explicitly setting autocommit off. But it errors out even when autocommit is set to ON and errors out with pragma autonomous_transaction declaration as well.

0

There are 0 answers