New answers tagged datapump
Short answer: CREATE TABLE must be explictly granted to the object owner for DBMS_DATAPUMP to be called from within a package or stored procedure. Long Answer: In an effort to solve this question, I interrogated the data dictionary to get all of the object and system privileges granted by the IMP_FULL_DATABASE and EXP_FULL_DATABASE roles (and all roles ...
Privileges acquired via roles are not effective in a stored procedure. You need to grant the required privileges to the account that creates the package.
Top 50 recent answers are included