DIRECTORY :
- Directory parameter is used for keeping dumpfiles and logfiles.
- Users running Data Pump operations are only able to read and write files in the directories that they have been granted access to.
- Before a user will be able to run a Data Pump operation, the administrator must pre-create a directory and grant privileges to the user on that directory. Unlike the non Data Pump version of Export and Import, users are unable to fully qualify the output file and log file.
- Oracle provides a default directory called DATA_PUMP_DIR if the directory has not been pre-created.
Directory Creation :-
SQL> CREATE OR REPLACE DIRECTORY test_dir AS '/u01/empdata'; Directory created. SQL> GRANT READ, WRITE ON DIRECTORY test_dir TO hari; Grant succeeded.
[oracle@18c ~]$ expdp hari/oracle directory=test_dir dumpfile=prod18c.dmp logfile=prod18c.log tables=hari.emp Export: Release 18.0.0.0.0 - Production on Tue Aug 21 21:14:11 2018 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Starting "HARI"."SYS_EXPORT_TABLE_01": hari/******** directory=test_dir dumpfile=prod18c.dmp logfile=prod18c.log tables=hari.emp Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER Processing object type TABLE_EXPORT/TABLE/TABLE . . exported "HARI"."EMP" 873.1 KB 100000 rows Master table "HARI"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded ****************************************************************************** Dump file set for HARI.SYS_EXPORT_TABLE_01 is: /u01/empdata/prod18c.dmp Job "HARI"."SYS_EXPORT_TABLE_01" successfully completed at Tue Aug 21 21:14:23 2018 elapsed 0 00:00:11
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
