Export Oracle Databse to Dump file

login to database as sysdba

SQL> CREATE DIRECTORY dmpdir AS 'D:\dumpDire';

Directory created.

SQL> GRANT read, write ON DIRECTORY dmpdir TO sys;

Grant succeeded.

SQL> SELECT directory_path FROM dba_directories WHERE directory_name = 'DATA_PUM

P_DIR';

DIRECTORY_PATH

---------------------------------------------------------------------------

D:\oracle\app\admin\orcl\dpdump\

SQL>  $ expdp user/user@orcl DIRECTORY=dmpdir DUMPFILE=dumpFileName.dmp;