OEL6.3 + 11.2.0.3.0 expdp 单表中一部分数据异常

Leo

OEL6.3+11.2.0.3.0单机
按条件导出某张表的时候，发现不正常. 该表大小1.81G.

[oracle@localhost lwhisadm_data]$ cat lwhisadm2.par
directory=EXPDP
dumpfile=D_FENCE_EVENT.dmp
nologfile=Y
QUERY=D_FENCE_EVENT:'"where trunc(TERMINALTIME)  between to_date('130401','YYMMDD') and  to_date('130531','YYMMDD') "'


[oracle@localhost lwhisadm_data]$ expdp lwhisadm parfile=lwhisadm2.par

Export: Release 11.2.0.3.0 - Production on һ 86 17:36:45 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
"LWHISADM"."SYS_EXPORT_SCHEMA_02":  lwhisadm/******** parfile=lwhisadm2.par
ʹLOCKS ...
SCHEMA_EXPORT/TABLE/TABLE_DATA
ʹLOCKS : 634.6 GB
SCHEMA_EXPORT/USER
SCHEMA_EXPORT/SYSTEM_GRANT
SCHEMA_EXPORT/ROLE_GRANT
SCHEMA_EXPORT/DEFAULT_ROLE
SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
SCHEMA_EXPORT/TABLE/TABLE
SCHEMA_EXPORT/TABLE/COMMENT
SCHEMA_EXPORT/TABLE/INDEX/INDEX
SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . LWHISADM"."D_HIS_TRACK":"HIS_TRACK_20130502"."SYS_SUBP1177"  9.099 GB  171509 ^C

当发现出现其他table数据时，果断终止了.
为啥会出现其他表，命令没有问题呀~
lunar 提示查看dba_datapump_jobs  ，dba_datapump_jobs 视图中的垃圾信息清除后，还是一样！

Mille

加tables 试试

Leo

刚换了种写法，ok了，是用的tables.

1. [oracle@localhost lwhisadm_data]$$ cat lwhisadm2.par
   
2. directory=EXPDP
   
3. dumpfile=D_FENCE_EVENT.dmp
   
4. nologfile=Y
   
5. QUERY="where trunc(TERMINALTIME)  between to_date('130401','YYMMDD') and  to_date('130531','YYMMDD') "
   
6. tables=D_FENCE_EVENT
   
7. 
   
8. [oracle@localhost lwhisadm_data]$$ expdp lwhisadm parfile=lwhisadm2.par
   
9. 
   
10. Export: Release 11.2.0.3.0 - Production on һ 86 18:12:02 2013
    
11. 
    
12. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
    
13. Password:
    
14. 
    
15. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    
16. With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
17. "LWHISADM"."SYS_EXPORT_TABLE_01":  lwhisadm/******** parfile=lwhisadm2.par
    
18. ʹLOCKS ...
    
19. TABLE_EXPORT/TABLE/TABLE_DATA
    
20. ʹLOCKS : 1.812 GB
    
21. TABLE_EXPORT/TABLE/TABLE
    
22. TABLE_EXPORT/TABLE/COMMENT
    
23. TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
    
24. . . LWHISADM"."D_FENCE_EVENT"                  1.421 GB 28950952 WHISADM"."SYS_EXPORT_TABLE_01"
    
25. ******************************************************************************
    
26. LWHISADM.SYS_EXPORT_TABLE_01 Ϊ:
    
27.   /u01/lwhisadm_data/D_FENCE_EVENT.dmp
    
28. "LWHISADM"."SYS_EXPORT_TABLE_01"  18:13:07

复制代码