日期:2014-05-16 浏览次数:20571 次
查看导入日志,发现错误如下:
oracle@sspt:/back/log> cat imp.HD_HDXX.log
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V10.02.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing GSYY's objects into GSYY
. . importing table "HD_HDXX"
IMP-00058: ORACLE error 1691 encountered
ORA-01691: unable to extend lob segment GSYY.SYS_LOB0000076833C00008$$ by 8192 in tablespace TBS_GSYY_DATA
IMP-00028: partial import of previous table rolled back: 3142033 rows rolled back
Import terminated successfully with warnings.
根据日志提示,TBS_GSYY_DATA表空间不足 ,查看表空间使用,发现TBS_GSYY_DATA确实不足:
SQL> select a.tablespace_name,a.bytes/1024/1024 "Sum MB",(a.bytes-b.bytes)/1024/1024 "used MB",b.bytes/1024/1024 "free MB",round(((a.bytes-b.bytes)/a.bytes)*100,2) "percent_used"
2 from
3 (select tablespace_name,sum(bytes) bytes from dba_data_files group by tablespace_name) a,
4 (select tablespace_name,sum(bytes) bytes,max(bytes) largest from dba_free_space group by tablespace_name) b
5 where a.tablespace_name=b.tablespace_name
6 order by ((a.bytes-b.bytes)/a.bytes) desc;
TABLESPACE_NAME Sum MB used MB free MB percent_used
------------------------------ ---------- ---------- ---------- ------------
TBS_GSYY_DATA 25000 24991.3125 8.6875 99.97
SYSTEM 720 719.375 .625 99.91
SYSAUX 560 531.875 28.125 94.98
EXAMPLE 330 310.125 19.875 93.98
U