ora-01654 problem
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?
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?
0