error with temp file and normal files

originally posted by User48687 (but as a Document)

Hi,

this is my first time here.

anyway during the weekend, i usually maintain our database and this weekend i end up with strange situation,

i lunched my scripts to reorginize datafiles, however the scripts is crash all the time due to weird message which is in my opinion is misleading ora message.

this is the situaion:

i am using this scripts to tell me if my datafiles are full or not

1 L_INDEX    24 107.12109375   103.74609375    3.375 0 96.8493600262553    3.15063997374467
2 L_TABLES   30 108.2939453125   97.1689453125   11.125 0 89.7270341680719   10.2729658319281

as you can see, the free space on the l_index tablespace is now 3G and need to reogrinze to free space, however when we run our scripts to free spaces, we recieve this message: