Dump Partial rows in a Tables

It's simple:

• If you have enough space on your disk, just create a temporary table and move the desired data to a new temporary table. Then dump the temporary table exp command:

$ exp [user]/[passwd] FILE=[filename].dmp FROMUSER=[username] TABLES=[tamporary table]

• If it's only one table (without join), you can directly use this syntax

exp [user]/[passwd] TABLES=[table] FILE=[filename].dmp query=\" where rownum<=10000\"