通过impdp导入用户的JOB
[oracle@ecard admin]$ impdp INCLUDE=SCHEMA_EXPORT/JOB network_link=job directory=dump logfile=job.log
Import: Release 10.2.0.1.0 - Production on Sunday, 10 January, 2010 17:50:35
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Username: ecard
Password:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
FLASHBACK automatically enabled to preserve database integrity.
Starting "ECARD"."SYS_IMPORT_SCHEMA_01": ecard/******** INCLUDE=SCHEMA_EXPORT/JOB network_link=job directory=dump logfile=job.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/JOB
Job "ECARD"."SYS_IMPORT_SCHEMA_01" successfully completed at 17:50:47
说明:
1.若不指定directory参数会报下面的错误:
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39145: directory object parameter must be specified and non-null
2. network_link=job中的job是到源ecard的database link
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7419833/viewspace-624874/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- UPGRADE CATALOG
- Linux oracle 10g 直接使用LUN创建ASM DISKGROUP
- How To : OCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE)
- DataGuard ORA-01119 ORA-27054错误解决
- Redhat Linux 5.6双网卡绑定
- RAC实验 新增节点
- RAC Failover测试及VIP漂移观察
- RAC客户端连接测试
- asm:ORA-00600: internal error code, arguments: [kfgFinalize_2]
- 清除10g RAC CRS的方法
