Oracle Database - Directory Object

Card Puncher Data Processing

How to

get the list of all directories

select * from ALL_DIRECTORIES;
OWNER DIRECTORY_NAME DIRECTORY_PATH
SYS DATA_DUMP_DIR_AIRLINE /mnt/data
SYS XMLDIR /u01/app/oracle/product/11.2.0/db/rdbms/xml
SYS DATAPUMP /u01/app/oracle/datapump
SYS DATA_PUMP_DIR /u01/app/oracle/admin/DIDB01/dpdump/
SYS ORACLE_OCM_CONFIG_DIR /u01/app/oracle/product/11.2.0/db/ccr/state

create a directory

create directory data_dump_dir as 'F:\Dumps';

Grant privileges

GRANT READ,WRITE ON DIRECTORY data_dump_dir to myUser1, myUser2;





Discover More
Data Pump Sqldeveloper
Oracle Database - Data Pump - (Export|Import) Utilities

Oracle Data Pump works with the file system of the database whereas Export and Import utilities works with the client file system. Since Oracle Database 10g, Oracle Data Pump enables movement of data...
Data Pump Sqldeveloper
Oracle Database - Data Pump Export (expdp)

In order to use Data Pump, the database administrator must create a directory object and grant privileges to the user on that directory object. If a directory object is not specified, a default directory...
Data Pump Sqldeveloper
Oracle Database - Data Pump Import (impdp)

The import utility of data pump In order to use Data Pump, the database administrator must create a directory object and grant privileges to the user on that directory object. If a directory...
Card Puncher Data Processing
Oracle Database - Objects

Database object. Each database object is considered to either be: a schema object (ie owned by a user) or a “non-schema object”. See for plsql object type: Object in different namespace are...
Card Puncher Data Processing
Oracle Database - Xml External Table

Xml externl table where: EXT_TABLE_DIR is an external directory Managing XML using Oracle's XMLDB Oracle® Database SQL Reference 10g Release 2 (10.2)...



Share this page:
Follow us:
Task Runner