imp导表失败，求教解决

tigerzt

日前作数据库数据备份,exp时compress默认为Y，生成dmp文件时无异常，但是由于数据库中有一个表字段很多而且记录数达到1000000以上，该表超过了80M。在使用imp username/password file=filename.dmp full=y ignore=y方式进行数据恢复时，出现大表导入失败，错误码1658。此错误应该是表过大所致，求教如何解决！该表纪录及其重要，一定要恢复的。请各位大虾打救，跪谢！

feijin

commit=y 试试看

tigerzt

使用了commit=y仍然不行，错误一样。各位高人指点啊！！！！

szhang

The meaningof Ora-1658 is as below.  Please check this table size, if this table size is bigger than 2Gbytes, you'd better create it with initial extent less 2Gbyte before import data.

SELECT SEGMENT_NAME, segment_type, MAX(EXTENT_ID), SUM(BYTES)/1024 KBYTES
FROM USER_EXTENTS
WHERE SEGMENT_NAME = 'YOUR_TABLE_NAME'
GROUP BY SEGMENT_NAME, segment_type;

ORA-01658 unable to create INITIAL extent for segment in tablespace string
Cause: Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created.
Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with a smaller value for INITIAL.

smilebbsxp

ignore=n