oracle expdp query(时间)

最新推荐文章于 2024-09-01 21:21:22 发布

iteye_18365

最新推荐文章于 2024-09-01 21:21:22 发布

阅读量772

点赞数

文章标签：数据库

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'"