Saturday, March 26, 2016

Creating A Directory In Oracle For DATAPUMP

Creating A Directory In Oracle For DATAPUMP

SQL> Connect /as sysdba

SQL> create or replace directory exp_dmp as ‘/oracle/backup/PROD1/expdp’;
Directory created.

Create a separate export user:

SQL> Connect /as sysdba

SQL> CREATE USER exportadmin IDENTIFIED BY oracle default tablespace users;
User created.

Grant Export and Import Privileges.

SQL> GRANT CONNECT,RESOURCE TO exportadmin;
Grant succeeded.

SQL> GRANT exp_full_database to exportadmin;
Grant succeeded.

SQL> alter user exportadmin quota unlimited on USERS;
User altered.

SQL> GRANT READ, WRITE ON DIRECTORY EXP_DMP to exportadmin;
Grant succeeded.

To check on which directories you have privilege to read & write:

SQL> SELECT privilege, directory_name FROM user_tab_privs t, all_directories d WHERE t.table_name(+)=d.directory_name ORDER BY 2,1;

No comments:

Post a Comment