Last updated on MAY 07, 2010
Applies to:PL/SQL - Version: 22.214.171.124
Information in this document applies to any platform.
***Checked for relevance on 07-May-2010***
ORA-01031 insufficient privileges
create or replace procedure test as
EXECUTE IMMEDIATE '
ALTER TABLE test_tab
MODIFY PARTITION part_test REBUILD UNUSABLE LOCAL INDEXES';
2.The table owner and procedure owner are the same and the procedure is being executed by the owner.
3.The procedure owner already has CREATE TABLE privilege granted explicitly i.e not via role.
4.All statements work fine in SQL*Plus
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms