how to export database using expdp export

To export oracle database using expdp follow the below steps:

1. Create Directory Path.

SQL> create directory BACKUP_DIR as '/backup/dailybackup';
Directory created.

SQL> grant read, write on directory BACKUP_DIR to system;
Grant succeeded.


2. Ensure the directory by following query.

SQL>
SELECT directory_path from dba_directories;
SELECT * from dba_directories;

3. exit from sql prompt.

SQL> exit;

4. To backup database in full export mode issue to following data pump command:

EXPORT FULL BACKUP
==================
[oracle@oracle ~]$ expdp system/manager full=y directory=BACKUP_DIR dumpfile='DB09MAR2017.dmp' logfile='DB09MAR2017.log';


EXPORT BACKUP of TABLESPACE
===========================
expdp hr/hr@ORCL DIRECTORY=exp_tblsp DUMPFILE=tablespace.dmp LOGFILE=tblsp_log.log TABLESPACES=USERS,EXAMPLE;
expdp system/manager DIRECTORY=BACKUP_DIR DUMPFILE=tablespace.dmp LOGFILE=tblsp_log.log TABLESPACES= PSIMAGE;