create or replace procedure mike.create_indexes as
execute immediate 'create index mike.ixa on id (id)';
when I run this query as user mike, it returns I dont have privileges..?!?!?!?! I ran it using dbms_job, got error... I tried then to run it manually, calling the proc, and got the same error.
I have create procedure and create any index privilege.
thanks in advance.