-
create index
create or replace procedure mike.create_indexes as
begin
execute immediate 'create index mike.ixa on id (id)';
end;
exec create_indexes
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.
F.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|