Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Creating Materialized View dynamically

428546Dec 21 2004 — edited Dec 22 2004

I am trying to create a MV using an execute immediate call from a stored proceudre but am running into insufficient priviliges errors.

If I take the string I'm passing to the NDS call and just run it in a sql window it works fine. The MV is complex but very straight forard, it selects from local tables and calls a couple of local functions.

Is this something I just can't do or am I missing some privs?

thx

jack

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 19 2005

Added on Dec 21 2004

#general-database-discussions

18 comments

2,046 views