oracle expdp query(时间)

最新推荐文章于 2021-05-13 21:13:24 发布

最新推荐文章于 2021-05-13 21:13:24 发布 · 813 阅读

文章标签：

#数据库

本文展示了如何使用SQL查询并导出特定日期范围内的数据，包括数据表结构、导出过程及导出文件的基本信息。

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