This content has been marked as final. Show 8 replies
does that user "TEST" is having permissions on DATA_PUMP_DIR directory? if not please grant permissions as below
SQL> grant read,write on directory DATA_PUMP_DIR to test;
then give a try
also, do user "test" is having execute procedure privilege?
Edited by: Pavan DBA on 21 Mar, 2013 4:46 PM
Does test user have right to execute data pump job exp_full_database, imp_full_database
user is exporting a single table (if you look at parfile content), then i don't think that user should have exp_full_database and imp_full_database roles.
Prem, I also observed that you are exporting emp table as test user. Do "test" user is having select permission on scott's emp table? If not you need to grant that also
SQL> grant select on scott.emp to test;
If you want "test" user to take full export, then test user should be granted with exp_full_database role
SQL> grant exp_full_database to test;
Thanks all for your time.
The job is being run as TEST user which invokes an external (OS) script. This script is performing the export. Do I have to grant read/write privilege to TEST user for the data pump dir in this case?
I will try to grant and test the job again and will post the results here.
Have you defined a credential for your host login with dbms_scheduler.create_credential and specified the credential with the job?
Oracle Certified Master DBA
yes we need to grant permissions on data pump directory, then only oracle will allow a user to take export in that location. this is newly introduced in datapump
Thanks everybody for your contribution.
The job is now running successfully after setting up the credentials. Thanks John.