Before you start, verify that the external directory exists and that the user who will be issuing
the create directory command has the CREATE ANY DIRECTORY system privilege.
396 Oracle Database 11g DBA Handbook
NOTE
In a default installation of Oracle Database 10g or 11g, a directory
object called DATA_PUMP_DIR is created and points to the directory
$ORACLE_BASE/admin/database_name/dpdump.
The following example creates a directory object called DPXFER in the Oracle instance dw
referencing the file system directory /Temp/DataPumpXfer and grants READ and WRITE access
to the user RJB:
SQL> create directory DPXFER as '/Temp/DataPumpXfer';
Directory created.
SQL> grant read, write on directory DPXFER to rjb;
Grant succeeded.
SQL>
The RJB user can now use the DPXFER directory for Data Pump jobs. The file system directory
/Temp/DataPumpXfer can exist on the source server, the target server, or any server on the network,
as long as each server can access the directory and the permissions on the directory allow read/
write access by the oracle user (the user that owns the Oracle executable files).
On the server oc1, the administrator creates a directory with the same name that references
the same network file system, except that privileges on the directory are granted to the HR user
instead:
SQL> create directory DPXFER as '/Temp/DataPumpXfer';
Directory created.
SQL> grant read,write on directory DPXFER to HR;
Grant succeeded.
Pages:
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618