Your table can have huge size or you may need to little piece of data from that huge table size.

In that point you can use dblink or you can use export table data with query options.

Here are the some quick steps.

For exporting table data with query condition

1. Create the directory if not present already.
   create directory EXPDIR as ‘xxx’
2. Find out quert for export data. In our case we want to get data from HR.EMPLOYEES last 60 new employees
   select * from HR.EMPLOYEES WHERE created > sysdate-60;
3. Run the EXPDP command for export query data.

expdp “‘/ as sysdba’” Directory=xxxx dumpfile=employeessmaple.dmp logfile=exp_employeessmaple.log tables=hr.employees query=hr.employees:”WHERE created > sysdate – 60″;

4. If you need a import dump you can use below syntax

impdp “‘/ as sysdba’” Directory=xxxx dumpfile=employeessmaple.dmp logfile=imp_employeessmaple.log