Oracle DBA

To export a table from a user

exp erp/erpp file=emp.dmp log=emp.log tables=emp rows=yes indexes=no

To export some tables from a user

exp erp/erpp file=emp.dmp tables=(emp,dept)

To export a subset of a table

exp erp/erpp tables=emp query="where deptno=10"

exp erp/erpp file=abc.dmp tables=abc query=\"where sex=\'f\'\" rows=yes

To import entire user 

imp erp/erpp file=emp.dmp full=yes

To import entire user from one user to another user

 
imp erp/erpp file=emp.dmp fromuser=scott touser=scott tables=dept

To import   user from one user to another user from entire database


imp erp/erpp file=emp.dmp fromuser=scott touser=scottnew 

Incremental Export 

  exp system/manager full=y inctype=incremental