Import and Export in Oracle

==================
To export
==================
SQL> CREATE DIRECTORY dmpdir AS '/opt/oracle';
Directory created.

SQL> GRANT read, write ON DIRECTORY dmpdir TO scott;
Grant succeeded

Oracle introduced a default directory from 10g R2, called DATA_PUMP_DIR, that can be used:

SQL> SELECT directory_path FROM dba_directories WHERE directory_name = 'DATA_PUMP_DIR';

DIRECTORY_PATH -------------------------------------------------------------------------------- /app/oracle/product/10.2.0/rdbms/log/

$ expdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp

===================
To import
===================

$ impdp system/oracle DIRECTORY=dmpdir DUMPFILE=scott.dmp

Thank You.