紧急求助，哪位热心的朋友帮助一下，谢谢

[Former Member]

在做集团复制时报错，是远程通过SCC8导出，提示ORA-00600 错误，数据库错误日志如下，哪位朋友帮助一下，谢谢：<br>

<br>

4 21:35:52 2010<br>

ORA-1654: unable to extend index SAPSR3.JEST~0 by 128 in tablespace PSAPSR3 <br>

ORA-1654: unable to extend index SAPSR3.JEST~0 by 1024 in tablespace PSAPSR3 <br>

Thu Mar 4 21:35:53 2010<br>

Errors in file /oracle/DEV/saptrace/usertrace/dev_ora_749630.trc:<br>

ORA-00600: internal error code, arguments: [kdtdelrow-2], [204], [204], [], [], [], [], []<br>

ORA-01654: unable to extend index SAPSR3.JEST~0 by 1024 in tablespace PSAPSR3<br>

Thu Mar 4 21:38:24 2010<br>

Incremental checkpoint up to RBA [0x7b14.441e.0], current log tail at RBA [0x7b17.94a1.0]<br>

Thu Mar 4 21:40:26 2010<br>

Completed checkpoint up to RBA [0x7b15.2.10], SCN: 310697596<br>

Thu Mar 4 21:40:44 2010<br>

Completed checkpoint up to RBA [0x7b16.2.10], SCN: 310701847<br>

Thu Mar 4 21:40:57 2010<br>

Completed checkpoint up to RBA [0x7b17.2.10], SCN: 310706050<br>

Thu Mar 4 22:08:42 2010<br>

Incremental checkpoint up to RBA [0x7b17.b0e8.0], current log tail at RBA [0x7b17.fe0c.0]<br>

Thu Mar 4 22:16:31 2010<br>

Beginning log switch checkpoint up to RBA [0x7b18.2.10], SCN: 310751424<br>

Thread 1 advanced to log sequence 31512<br>

Current log# 4 seq# 31512 mem# 0: /oracle/DEV/origlogB/log_g14m1.dbf<br>

Current log# 4 seq# 31512 mem# 1: /oracle/DEV/mirrlogB/log_g14m2.dbf<br>

Thu Mar 4 22:21:30 2010<br>

Completed checkpoint up to RBA [0x7b18.2.10], SCN: 310751424<br>

Thu Mar 4 22:35:03 2010<br>

Beginning log switch checkpoint up to RBA [0x7b19.2.10], SCN: 310846291<br>

Thread 1 advanced to log sequence 31513<br>

Current log# 3 seq# 31513 mem# 0: /oracle/DEV/origlogA/log_g13m1.dbf<br>

Current log# 3 seq# 31513 mem# 1: /oracle/DEV/mirrlogA/log_g13m2.dbf<br>

Thu Mar 4 22:39:14 2010<br>

Incremental checkpoint up to RBA [0x7b18.137af.0], current log tail at RBA [0x7b19.5b53.0]<br>

Thu Mar 4 22:40:04 2010<br>

Completed checkpoint up to RBA [0x7b19.2.10], SCN: 310846291<br>

Thu Mar 4 22:50:38 2010<br>

Beginning log switch checkpoint up to RBA [0x7b1a.2.10], SCN: 310946302<br>

Thread 1 advanced to log sequence 31514<br>

Current log# 1 seq# 31514 mem# 0: /oracle/DEV/origlogA/log_g11m1.dbf<br>

Current log# 1 seq# 31514 mem# 1: /oracle/DEV/mirrlogA/log_g11m2.dbf<br>

Thu Mar 4 22:55:31 2010<br>

Completed checkpoint up to RBA [0x7b1a.2.10], SCN: 310946302<br>

Thu Mar 4 23:05:01 2010<br>

Beginning log switch checkpoint up to RBA [0x7b1b.2.10], SCN: 311022934<br>

Thread 1 advanced to log sequence 31515<br>

Current log# 2 seq# 31515 mem# 0: /oracle/DEV/origlogB/log_g12m1.dbf<br>

Current log# 2 seq# 31515 mem# 1: /oracle/DEV/mirrlogB/log_g12m2.dbf<br>

Thu Mar 4 23:09:52 2010<br>

Completed checkpoint up to RBA [0x7b1b.2.10], SCN: 311022934<br>

Thu Mar 4 23:09:53 2010<br>

Incremental checkpoint up to RBA [0x7b1b.34c.0], current log tail at RBA [0x7b1b.57b0.0]<br>

Thu Mar 4 23:25:05 2010<br>

Beginning log switch checkpoint up to RBA [0x7b1c.2.10], SCN: 311112838<br>

Thread 1 advanced to log sequence 31516<br>

Current log# 4 seq# 31516 mem# 0: /oracle/DEV/origlogB/log_g14m1.dbf<br>

Current log# 4 seq# 31516 mem# 1: /oracle/DEV/mirrlogB/log_g14m2.dbf<br>

Thu Mar 4 23:30:12 2010<br>

Completed checkpoint up to RBA [0x7b1c.2.10], SCN: 311112838<br><br>

Edited by: Sheng Qiang on Jun 19, 2010 9:09 AM

[Former Member · Accepted solution]

ORA-01654: unable to extend index string.string by string in tablespace string

Cause: Failed to allocate an extent of the required number of blocks for an index segment in the tablespace indicated.

Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

应该是表空间不足，检查硬盘空间是否足够。

[Former Member · Accepted solution]

硬盘空间是有的，数据库表是自动扩展

[Former Member]

暂处理不了.

[Former Member]

The tablespace the index is residing in is unable to extend.

There is not enough space left either due to the datafiles being full, autoextend which is not set at datafile level or due to a disk which's full.

You'll have to check the size of the datafiles attached to the tablespace and check whether they can autoextend or not.

select file_name, bytes, autoextensible, maxbytes

from dba_data_files

where tablespace_name='TABLESPACE_NAME'

Either add more datafiles to the tablespace, set the autoextensible flag or enlarge the datafile(s).

To add more space to a file issue following command:

alter database datafile 'C:\ORACLE\ORADATA\IDX01.DBF' resize 1000m;

To turn on the autoextend feature on a datafile use following command:

alter database datafile 'C:\ORACLE\ORADATA\IDX01.DBF' autoextend on next 100m maxsize 2000m;

To add a new datafile to the tablespace use following command:

alter tablespace IDX add datafile 'C:\ORACLE\ORADATA\IDX02.DBF' size 100m autoextend on next 100m maxsize 2000m;