SQL> SQL> select * from a1; 


 A           B C 

 -- ---------- ------------------- 

 a          10 2011-11-30 10:47:30 

 b          99 2011-11-29 10:47:54 

 c           3 

 b          99 2011-11-29 10:47:54 
c           5

-----------------
 Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production 

 With the Partitioning, OLAP, Data Mining and Real Application Testing options 

 Starting "AIKI"."SYS_EXPORT_TABLE_01":  aiki/******** parfile=file.par 

 Estimate in progress using BLOCKS method... 

 Processing object type TABLE_EXPORT/TABLE/TABLE_DATA 

 Total estimation using BLOCKS method: 128 KB 

 Processing object type TABLE_EXPORT/TABLE/TABLE 

 Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS 

 . . exported "AIKI"."A1"                                 5.539 KB       2 rows 

 Master table "AIKI"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded 

 ****************************************************************************** 

 Dump file set for AIKI.SYS_EXPORT_TABLE_01 is: 

   /home/oracle/aiki/aaai.dmp 

 Job "AIKI"."SYS_EXPORT_TABLE_01" successfully completed at 11:51:21 


 $ $more file.par 

 DIRECTORY=AIKI_DIR 

 DUMPFILE=aaai.dmp 

 tables=a1 

 QUERY=a1:"where to_char(c,'yyyymmdd')='20111129'"