1:带where参数的导出数据
exp m/a@192.168.0.1/orc11u file="rry_all.dmp" log="ll_exp.log" tables=rry query=\"where (to_char(upload_date, 'YYYY-MM-DD')<'2015-04-01') AND upload_date IS NOT NULL AND valid_flag=1\"
exp m/a@192.168.0.1/orc11u file="rry_all.dmp" log="ll_exp.log" tables=rry query=\"where (to_char(upload_date, 'YYYY-MM-DD')<'2015-04-01') AND upload_date IS NOT NULL AND valid_flag=1\"