Link to home
Start Free TrialLog in
Avatar of ebi168
ebi168

asked on

ORA-1654: unable to extend index SAP_U1 by 130 in tablespace IDXTB

Hi,

In error message

ORA-1654: unable to extend index SAP_U1 by 130 in tablespace IDXTB,

what does 130 means here, 130 bytes?

Thanks
SOLUTION
Avatar of marianna6000
marianna6000
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of muskware77
muskware77
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ebi168
ebi168

ASKER

Thanks for the information. One more question is that during data loading, oracle looks for one extent, then another,..., when it comes to the point it couldn't find another extent, it fails. By then it calculate and get that 130 blocks are missing. It is not like at the beginning of loading, it knows the problem and hauls. Am I right?
Avatar of ebi168
ebi168

ASKER

In this case, are those data fit into the storage loaded into the table?
Avatar of muskware77
muskware77
Hi ebi168,
If i understand you correctly, you think Oracle despite the lack of space will
store the data in the available space and report an error with regard to the missing blocks. I'm afraid it doesn't work that way. I am confident Oracle will not add _any_ data in the table if space requirements are not met.

HTH.