ORA-39171: Job is experiencing a resumable wait

本文介绍了解决Oracle数据泵导入过程中因表空间分配问题导致的错误的方法。通过停止并重启导入任务,修复表空间错误,成功完成数据导入。

开发板推荐:天空星STM32F407VET6开发板

超高性价比 STM32主控 | 超高主频 | 一板兼容百芯 | 比赛神器 | 沉金彩色丝印

In the datapump import phase you get errors related to tablespace allocation. For example you don't have any more space left at the filesystem. So at the import you have errors:

Import: Release 10.2.0.5.0 - 64bit Production on Wednesday, 25 April, 2012 12:06:16

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/******** DIRECTORY=DWH_TRANSFER_DIR DUMPFILE=DM1_DM2_TARGET_BILL_DETAIL.dmp parfile=target_bill_par.par 
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39171: Job is experiencing a resumable wait.
ORA-01658: unable to create INITIAL extent for segment in tablespace STG_TAB

How to restart Datapump
1. In the IMPDP command line, press CTRL-C to stop the job.
2. At the command line of the import
Import> stop_job=immediate
Are you sure you wish to stop this job ([yes]/no): y

3. Fix the tablespace error
4. Attach again the job. Check sqlplus>SELECT * FROM DBA_DATAPUMP_JOBS;
Use the job name which is something like "SYS_IMPORT_FULL_*"

$impdp system/**** attach=SYS_IMPORT_FULL_01

5. At the command line of the import
Import> start_job
6. Check sqlplus>SELECT * FROM DBA_DATAPUMP_JOBS; It is running again.

开发板推荐:天空星STM32F407VET6开发板

超高性价比 STM32主控 | 超高主频 | 一板兼容百芯 | 比赛神器 | 沉金彩色丝印

评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值