Database Administration (MOSC)

MOSC Banner

ora-01654 problem

edited Feb 4, 2009 6:23AM in Database Administration (MOSC) 7 commentsAnswered
 ora-01654 problem
I load data to a table and get the error:
ORA-1654: unable to extend index AS.CI_OLD_PK by 1280 in tablespace IND_TBS_NA

my index tablespace IND_TBS_NA has 6 datafile, and every file has 20G,my block_size is 8K, 1280x8=10G.
the tablespace NO.5 datafile has 10G free space and NO.6 has 8G free space, the index always use NO.6 datafile and unable extend!

my question is how to restrict the index segment use what datafile? if we can't, how to fix it? my database always use the 'smaller' datafile and return error? 

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