微软 windows [版本10.0.14393]（c）2016微软公司。保留所有权利。
C:\Users\Administrator>expdp USERNAME/*****@db FULL=Y VERSION=12.1 DIRECTORY=Load_Dump DUMPFILE=fNAMe.DMP LOGFILE=NAme.log parallel=4
Export: Release 12.1.0.2.0 - Production on Mon Jul 20 11:11:57 2020
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
WARNING: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.
......
------------------------------------------------------------------------------
Resumable stmt status: SUSPENDED
Resumable stmt start: 07/20/20 11:14:02 stmt suspend: 07/20/20 11:14:03
ORA-39171: Job is experiencing a resumable wait.
Resumable error: ORA-01691: unable to extend lob segment DBUSER.SYS_LOB0000109481C00100$$ by 128 in tablespace DBTBS
Resumable stmt: INSERT INTO "DBUSER"."SYS_EXPORT_FULL_01" (object_type_path, object_path_seqno, dump_fileid, dump_position,dump_length, dump_orig_length, dump_allocation, process_order, duplicate, object_row, object_type, object_schema, original_object_schema, object_name, object_long_name, original_object_name, partition_name, subpartition_name, object_tablespace, grantor, flags, processing_state, processing_status, base_process_order, base_object_type, base_object_schema, base_object_name, domain_process_order, xml_clob, ancestor_process_order, property, trigflag, size_estimate, creation_level, parent_process_order, value_n, object_int_oid, metadata_io, tde_rewrapped_key, option_tag, orig_base_object_schema, parallelization, unload_method) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :13, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43)
2条答案
按热度按时间bq8i3lrv1#
你没有数据泵问题，而是存储问题。数据泵作业将挂起，直到问题解决。
你的线索：
数据泵中的可恢复错误是一种可恢复的错误，它意味着作业被挂起，直到产生挂起的问题得到修复。
增加表空间DBTBS，作业将继续。
ctehm74n2#
正如@Roberto提到的，这是由于表空间大小问题，您可以扩展表空间大小。在我的例子中，我打开了自动扩展，但是超出了最大大小。您可以扩展最大表空间大小并恢复导入过程。
假设4000 M将是您的DB导入的最大限制。