最新消息:20181230 VPS服务器已从Linode换到腾讯云香港,主题仍用朋友推荐的大前端D8

【已解决】再次impdp出错:ORA-01658: unable to create INITIAL extent for segment in tablespace

工作和技术 crifan 652浏览 0评论

之前用:

impdp ‘xxx_tem/xxx_tem‘ directory=DATA_PUMP_DIR dumpfile=follow.dmp REMAP_SCHEMA=SBPOPT:xxx_tem REMAP_TABLESPACE=DATA02:xxx_tem

但是中断了

所以去杀掉进程后

重新去执行:

impdp ‘xxx_tem/xxx_tem‘ directory=DATA_PUMP_DIR dumpfile=follow.dmp REMAP_SCHEMA=SBPOPT:xxx_tem REMAP_TABLESPACE=DATA02:xxx_tem

结果出错:


Import: Release
11.2.0.1.0 – Production on Mon Apr 10 21:11:17 2017


Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release
11.2.0.1.0 – 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options

ORA-39006: internal error

ORA-39068: invalid master table data in row with PROCESS_ORDER=-4

ORA-01658: unable to create INITIAL extent for segment in tablespace xxx_tem


ORA-39097: Data Pump job encountered unexpected error -1658

搜:

ORA-01658: unable to create INITIAL extent for segment in tablespace xxx_tem

参考:

ORA-01658: unable to create INITIAL extent for … | Oracle Community

alter database datafile ‘/opt/oracle/data/large_index02.dbf’ autoextend on;

Oracle ORA-01658 Unable to Create INITIAL Extent for Segment in Tablespace Error – Tech Journey

ORA-01658: unable to create INITIAL extent tips

oracle – ORA-01658: unable to create INITIAL extent for segment in tablespace TS_DATA – Stack Overflow

ALTER DATABASE DATAFILE ‘C:\ORACLEXE\APP\ORACLE\ORADATA\XE\TS_DATA.DBF’ RESIZE 3000M;

即可。

转载请注明:在路上 » 【已解决】再次impdp出错:ORA-01658: unable to create INITIAL extent for segment in tablespace

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址
61 queries in 0.067 seconds, using 9.36MB memory