导入tacustomer表,记录数200万左右,单条记录的长度上限约为800Byte,但一般都在200Byte以下。从PL/SQL Developer中执行导入程序3分钟左右后,自行停止。想把tacustomer表drop掉,结果报错:
察看bdump/alert_oralot.log文件,发现如下信息:
Wed Apr 25 09:21:54 2007
ORA-1653: unable to extend table TA.TACUSTOMER by 1024 in tablespace TS_TA
Wed Apr 25 09:24:43 2007
ORA-1654: unable to extend index TA.IDX_CRNAME by 128 in tablespace TS_TA
ORA-1654: unable to extend index TA.IDX_CRNAME by 128 in tablespace TS_TA
Wed Apr 25 09:24:56 2007
Thread 1 cannot allocate new log, sequence 13
All online logs needed archiving
Current log# 2 seq# 12 mem# 0: D:/ORACLE/ORADATA/ORALOT/REDO02.LOG
这个问题该如何解决?