Customer doesn't have SYS.DATA_PUMP_DIR created in their Database. They need to know how the space will be used.
-- Grant to allow STAT use of Data Dump GRANT READ, WRITE ON DIRECTORY SYS.DATA_PUMP_DIR TO STAT;
RESOLUTION:
When a database is created in Oracle a default directory called DATA_PUMP_DIR is created automatically. I believe this was effective in Oracle 10g R2, so any Oracle release before this may not find this directory. The easiest way to find this directory is in Toad for Oracle Schema Browser, under schema STAT check out the tab “Directories”, and look at tab for “Grants”. Try it yourself to verify.
This is the Oracle default directory where the dump file is placed anytime a Data Pump Export is done.
This directory is only available to users with the privilege granted. So, STAT does not have the privilege to run the Data Pump export unless it is granted write to this directory. And that is why we grant this in the STAT installation script to allow STAT to export the database in the future if needed.
This is done to assist the DBA to have one less thing to do when running a database export. If the DBA wants to do this manually later as needed they can comment this out, but have to remember to run this before any Data Pump Export will work.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center