When rebuilding an index online Oracle will create a journal table in the schema where the index resides.
Thus said, you will get this error if you are trying to rebuilding an index thru a procedure using execute immediate even though you are the owner of the table/index/procedure.
You have to have direct grants on every operation when executing using execute immediate.
So, have "grant create table" "grant alter any index" and you should be good.
Thus said, you will get this error if you are trying to rebuilding an index thru a procedure using execute immediate even though you are the owner of the table/index/procedure.
You have to have direct grants on every operation when executing using execute immediate.
So, have "grant create table" "grant alter any index" and you should be good.
No comments:
Post a Comment