ITPub博客

首页 > Linux操作系统 > Linux操作系统 > impdp遭遇undo空间不足

impdp遭遇undo空间不足

原创 Linux操作系统 作者:BTxigua 时间:2011-12-09 22:55:56 0 删除 编辑
impdp导入备份数据的时候,碰到了temp表空间不足。
ORA-39171: Job is experiencing a resumable wait.
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
 
紧接着又碰到了undo表空间不足
ORA-39171: Job is experiencing a resumable wait.
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
 
在老的imp工具下,我们可以使用commit=y来解决这个问题,但是impdp却没这个参数。查了一下metalink,找到了解决办法,在
Run Out Of Space On Undo Tablespace Using Import/Export DataPump [ID 735366.1]
中描述有办法,使用参数:access_method=direct_path
 
执行成功:
Starting "ULTRANMS"."SYS_IMPORT_TABLE_03": 
ULTRANMS/******** DIRECTORY=unidp TABLES=PM_RAW_Z_RESINTERFACE \
REMAP_SCHEMA=ULTRANMS:ULTRANMS TABLE_EXISTS_ACTION=truncate \
LOGFILE=impdp.ultranms.pm_raw_z_resinterface.log \
access_method=direct_path dumpfile=expdp_full.dmp
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
ORA-39153: Table "ULTRANMS"."PM_RAW_Z_RESINTERFACE" exists and has been truncated. Data will be loaded but all dependent metadata wi
ll be skipped due to table_exists_action of truncate
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "ULTRANMS"."PM_RAW_Z_RESINTERFACE"          2.225 GB 64433905 rows
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Job "ULTRANMS"."SYS_IMPORT_TABLE_03" completed with 1 error(s) at 18:12:49

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10867315/viewspace-713081/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-01-31

  • 博文量
    101
  • 访问量
    284694