[펌] SQL*Loader-605 에러발생시.. (extent 에러)

** 에러내용 **

ORA-01631: max # extents (121) reached in table user_id.table_name
ORA-01631: max # extents (121) reached in table user_id.table_name
SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued.

위 경우는 세그먼트(테이블이나인덱스) extent 가 한계치에 달하였을 경우 발생되는 에러라고 하네요..

alter table 테이블이름 storage (next 10M maxextents unlimited);
alter table 테이블이름 storage(maxextents unlimited);
alter index 인덱스이름 storage ( next 10M  maxextents 255);

cf) 현재 extent 수가 max extent 의 90% 이상인것 조회하기..

select Owner,Tablespace_Name,Segment_Name,Segment_Type,
       round(Bytes/1024/1024, 2) as "cur_Size(MB)",
       Extents, max_extents,
       initial_extent/1024 as "initial_extent(KB)",
       next_extent/1024 as "next_extent(KB)"
 from DBA_SEGMENTS
 Where owner <> 'SYS'
   and extents > (max_extents * 0.9)     /* 현재 extents 90% 이상인것 */
 Order By Owner, Tablespace_Name,Segment_Type,Segment_Name;

[출처] http://cafe.naver.com/sanovice/197