-- Юзер  
CREATE USER "MYUSER" IDENTIFIED BY 123  ;  
    
-- Права
GRANT CONNECT TO MYUSER ;  
GRANT CREATE TABLE TO MYUSER ;
GRANT CREATE TRIGGER TO MYUSER ;
GRANT CREATE ANY INDEX TO MYUSER ;

-- DDL триггер
create or replace NONEDITIONABLE TRIGGER MYUSER.MYUSER_CREATE_TABLE_INDEX
AFTER CREATE ON MYUSER.SCHEMA

    DECLARE
    cSQL varchar2(4000 CHAR);
   BEGIN
    cSQL := 'create index MYUSER.idx_test on MYUSER.test(f1)';
    EXECUTE IMMEDIATE cSQL;

   END MYUSER_CREATE_TABLE_INDEX;

-- Выполняю от юзера MYUSER
create table  MYUSER.test (f1 nvarchar2(10));

-- Получаю ошибку
rror starting at line : 1 in command -
create table  MYUSER.test (f1 nvarchar2(10))
Error report -
ORA-04088: ошибка во время выполнения триггера 'MYUSER.MYUSER_CREATE_TABLE_INDEX'
ORA-00604: ошибка на рекурсивном SQL-уровне 1
ORA-30511: неверная DDL операция в системных триггерах
04088. 00000 -  "error during execution of trigger '%s.%s'"
*Cause:    A runtime error occurred during execution of a trigger.
*Action:   Check the triggers which were involved in the operation.

grant create any index to MYUSER;
-- была некоторая неоднозначность :)
revoke create any index from MYUSER

CREATE OR REPLACE
  TRIGGER MYUSER.MYUSER_CREATE_TABLE_INDEX_TRG
    AFTER CREATE
    ON DATABASE

select count(1) 
  from dba_segments where segment_type = 'INDEX'

select count(1) from DBA_INDEX_USAGE
--
-- 2391 из 126118