1.Create directory di database yang digunakan untuk menampung file dmp maupun log dari export data pump.
* conn database as system
* select * from all_directories
* CREATE DIRECTORY directory_name as 'path'
* grant read , write on directory_name to user
2.expdp username/password@db dumpfile=nama_file_dump.dmp directory=directory_name [point1] logfile=logfile_name.log
expdp -help --> another option
* schemas=[schema_name] --> schema yang di exp
* tables=[list of table] --> table yang akan di exp
3.impdp username/password@db dumpfile=nama_file_dump.dmp directory=directory_name [point1] logfile=logfile_name.log
impdp -help --> another option
* remap_shema=[old_shema]:[new_schema] --> imp ke schema lain
