Database Administration (MOSC)

MOSC Banner

Why are we getting error ORA-01654: unable to extend index IM_STAGE.S1REUTERS_RIC_IDX3 by 640 in ta

edited Jan 5, 2011 5:20AM in Database Administration (MOSC) 4 commentsAnswered
show parameter block_size
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_block_size                        integer     16384
SQL:sldn0977por:(EIMP1):PRIMARY> select file_name, MAXBLOCKS,AUTOEXTENSIBLE from dba_data_files where tablespace_name='STAGE_INDEX_LRG';

FILE_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------
MAXBLOCKS AUT
---------- ---
/sbcdata/02/oradata/EIMP1/EIMP1_stage_index_lrg_01.dbf
        0 NO

/sbcdata/03/oradata/EIMP1/EIMP1_stage_index_lrg_02.dbf
        0 NO

/sbcdata/03/oradata/EIMP1/EIMP1_stage_index_lrg_03.dbf
        0 NO


SQL:sldn0977por:(EIMP1):PRIMARY> SELECT initial_extent,next_extent,pct_increase,extent_management, allocation_type ,segment_space_management
FROM dba_tablespaces where TABLESPACE_NAME='  2  STAGE_INDEX_LRG';

INITIAL_EXTENT NEXT_EXTENT PCT_INCREASE EXTENT_MAN ALLOCATIO SEGMEN

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center