Data Pump Grant create any directory
kumarskDec 9 2010 — edited Dec 9 2010Hi,
I have created the directory to use EXPDP utility as below.
SQL>CREATE DIRECTORY test_expdp AS '/export/oracle/';
1)
SQL>GRANT READ, WRITE ON DIRECTORY test_expdp TO system ;
With the above grant command to directory for system user, this is enough to take the full database backup ,right?.
If i take schema wise backup ,the backup will get generate right , since i gave grant to SYSTEM user .
2)
SQL>GRANT READ, WRITE ON DIRECTORY test_expdp TO public ; Will this give grant to all users?.If not, how to give grant to all existing users in database,so that can take backup on schema or system or sys wise.
3)
Can i use impdp utility to import file , which the file had generated using exp utility?.