今天帮人导一个表,老是报对象不存在。
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;