Oracle Export/Import dump file

gistfile1.sql

-- DBA define dump directory for remote and local db --
C:\>sqlplus system/password@tns_name as sysdba
SQL> CREATE DIRECTORY data_dump_dir AS 'D:\oraclexe\dump';
SQL> GRANT read,write ON DIRECTORY data_dump_dir TO username;
SQL> SELECT directory_name, directory_path FROM dba_directories;

--- EXPORT FROM REMOTE DB ---
C:\>expdp username/password@tns_name DIRECTORY=data_dump_dir DUMPFILE=database.dmp SCHEMAS=database LOGFILE=database.log
C:\>expdp username/password@tns_name DIRECTORY=data_dump_dir DUMPFILE=database.dmp TABLES=table_user,table_product LOGFILE=database.log

-- IMPORT TO LOCAL DB ---
C:\>sqlplus username/password@xe
SQL> DROP TABLE table_user CASCADE CONSTRAINTS;
SQL> DROP TABLE table_product CASCADE CONSTRAINTS;
SQL> PURGE recyclebin;

C:\>impdp username/password@xe DIRECTORY=data_dump_dir DUMPFILE=database.dmp SCHEMAS=database LOGFILE=database.log
C:\>impdp username/password@xe DIRECTORY=data_dump_dir DUMPFILE=database.dmp TABLES=table_user,table_product LOGFILE=database.log