Dump file and logs are located on server side under defined directory in the database.
PL/SQL API: DBMS_DATADUMP
--
--1. Create a directory
--
$ mkdir /test
CONNECT / AS SYSDBA
-- Create directory
create or replace directory TEST_DIR as '/test';
GRANT READ,WRITE ON DIRECTORY TEST_DIR TO scott;
--
--Drop Directory
--
DROP DIRECTORY TEST_DIR;
--
--2. Related Views
--
dba_directories, all_directories
--check privilieges
--
all_tab_privs, user_*,dba_*
all_tab_privs_made, user_tab_privs_made
all_tab_privs_recd, user_tab_privs_recd
--
--3.Estimate export dump before it gets underway
--
expdp mydbauser/mydbapwd ESTIMATE_ONLY=Y SCHEMA=myschema DIRECTORY=TEST_DIR
expdp mydbauser/mydbapwd ESTIMATE_ONLY=Y FULL=Y DIRECTORY=TEST_DIR
--
--Dump
--
expdp mydbauser/mydbapwd DIRECTORY=TEST_DIR SCHEMA=myschema DUMPFILE=schema_dmp LOGFILE=schema_log
expdp mydbauser/mydbapwd DIRECTORY=TEST_DIR FULL=Y DUMPFILE=fulldb_dmp LOGFILE=fulldb_log
--
--4.Monitor Export Dump job
--
select * from dba_datapump_jobs;
