expdp test/test directory=test_dir dumpfile=test.dmp query=emp:\"where salary\>10000\ order by salary" tables=emp
Easy a would be pass the query parameter through a file.
exp test@testdb tables=test_export parfile=test_query.par
Inside of test_query.par, it contains only one parameter query:
Query=”where salary >10000 order by salary"
http://wiki.oracle.com/page/Oracle+export+and+import+
http://www.orafaq.com/wiki/Import_Export_FAQ
To verify user privileges:
select * from dba_sys_privs;
select * from dba_role_privs;
select * from dba_tab_privs;
select * from user_sys_privs;
select * from user_role_privs;
select * from user_tab_privs;
select * from all_sys_privs;
select * from all_role_privs;
select * from all_tab_privs;
select * from role_sys_privs;
select * from role_role_privs;
select * from role_tab_privs;
