expdp导出问题亲身体验！

今天帮人导一个表，老是报对象不存在。

desc 又可以看到这个“表”，然后，发现是个同义词！

找到同义词对应的表，导出完成！！！

还有停止一个expdp的job，不能只是crtl+c，这个停止不了

要select job_name,state from dba_datapump_jobs

[oracle@database ~]$ expdp \"sys/oracle as sysdba\" attach=SYS_EXPORT_SCHEMA_02
Export: Release 11.2.0.4.0 - Production on Mon Jan 26 10:31:42 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Job: SYS_EXPORT_SCHEMA_02
  Owner: SYS                            
  Operation: EXPORT                         
  Creator Privs: TRUE                           
  GUID: 0D85DF9D2F014494E053A80013AC483D
  Start Time: Monday, 26 January, 2015 10:27:03
  Mode: SCHEMA                         
  Instance: orcl
  Max Parallelism: 1
  EXPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        "sys/******** AS SYSDBA" schemas=(prod,tts_fnd,tts_cms,tts_hr,tts_ecm,tts_coa,tts_exm,tts_htm) dumpfile=tt.dmp logfile=tt.log directory=test 
  State: EXECUTING                      
  Bytes Processed: 17,595,108,512
  Percent Done: 81
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: /oracle/backup/tt.dmp
    bytes written: 17,610,469,376  
Worker 1 Status:
  Process Name: DW00
  State: EXECUTING                      
  Object Schema: TTS_EXM
  Object Name: EXM_PERSON_ITEMS
  Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
  Completed Objects: 80
  Total Objects: 1,400
  Worker Parallelism: 1
Export> stop_job=immediate 
Are you sure you wish to stop this job ([yes]/no): yes   
[oracle@database ~]$ 

在此查看视图dba_datapump_jobs

发现SYS_EXPORT_SCHEMA_02已经是not runing状态了

expdp his/his TABLES=PHIS_CHSS.PERSON_MAIN dumpfile=FHA_PERSON_MAIN.dmp DIRECTORY=expdp_dir;