Export of tables based on a query

1. Export table names starting with 'ce'

exp user/password  file=abc.dmp tables=ce% log=abc.log statistics=none buffer=1000000

  

Here tables=ce%  -- means table names starting with 'ce'

2. Export table names starting with 'ce' and 20 rows from each table

exp cellpay/cellpay  file=/bkup/cellpay.dmp tables=Ce% log=/bkup/cellpay.log statistics=none buffer=1000000 query=\'where rownum \<\= 20\'

   query=\'where rownum \<\= 20\'