|
-
My question is :
Trying to create a materialsed view using execute immediate and comes up with the following error:
QL> exec xxma_build_pace_views_pkg.build_pace_views;
BEGIN xxma_build_pace_views_pkg.build_pace_views; END;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "PACE.XXMA_BUILD_PACE_VIEWS_PKG", line 30
ORA-06512: at line 1
What privileges do I need to create materialised view using 'execute immediate'?
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
|
Reply With Quote