ORACLE Directory directory Management steps

ORACLE Directory Directory management steps

Oracle 's directory is a directory path in the database and needs to be mapped to the corresponding directory in the operating system; The role of the Oracle directory is to make ORACLE database and operating system before the file interaction, the most common is the import and export of data pump;

Management steps for DIRECTORY:

1.creation: Create[OR REPLACE] Directory directory as ' pathname ';

For example: CREATE OR REPLACE DIRECTORY DIR as ' F:\expbak ';

2.Empowering:GRANT Read[,write] on the directory directory to username;

For example:Grant read, write on directory Exp_dir to John;

3 . How to query directory

SELECT * from Dba_directories;

4, Delete:drop directory datachk_dump;

5. Export data to the appropriate directory via data pump

The export can be directly associated with directory directly to write dumpfile filename interface,Oracle will be exported to the appropriate directory.

EXPDP \ "/As Sysdba\" Directory=dir_exp dumpfile=party.photo_compare_info_201612.dmp tables=party.photo_compare_info _201612 Logfile=expdp_party.photo_compare_info_201612.log

ORACLE Directory directory Management steps