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;
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