之前用：
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
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