help tablespace

From: zichy <jamiro1976_at_libero.it>
Date: Sat, 5 Apr 2008 10:13:16 -0700 (PDT)
Message-ID: <3c185800-a9ad-4c58-b7f8-f2d3a05bbbeb@q10g2000prf.googlegroups.com>

hi,
i have this query:
SELECT count(*)
FROM
  L_VEHICLE,
  FT_JOURNEY_STREET_CAT,
  L_STREET_CAT,
  L_ARG L_ARG2,
  (
  SELECT DISTINCT FT_JOURNEY_STREET_CAT.ID_DRIVER, FT_JOURNEY_STREET_CAT.ID_VEHICLE, R_VEHICLE_DRIVER.ID_ARG FROM FT_JOURNEY_STREET_CAT, R_VEHICLE_DRIVER WHERE FT_JOURNEY_STREET_CAT.ID_DRIVER = R_VEHICLE_DRIVER.ID_DRIVER OR FT_JOURNEY_STREET_CAT.ID_VEHICLE = R_VEHICLE_DRIVER.ID_VEHICLE   ) DER_VIAGGI_ARG
WHERE
  ( L_ARG2.ID_ARG=DER_VIAGGI_ARG.ID_ARG )

  AND  ( FT_JOURNEY_STREET_CAT.ID_VEHICLE=L_VEHICLE.ID_VEHICLE  )
  AND  ( DER_VIAGGI_ARG.ID_DRIVER=FT_JOURNEY_STREET_CAT.ID_DRIVER  )
  AND  ( DER_VIAGGI_ARG.ID_VEHICLE=FT_JOURNEY_STREET_CAT.ID_VEHICLE  )

  AND
( FT_JOURNEY_STREET_CAT.STREET_CATEGORY=L_STREET_CAT.ID_STREET_CAT )   AND FT_JOURNEY_STREET_CAT.FL_PRIVACY = '0' WITHOUT THE CONDITION FT_JOURNEY_STREET_CAT.FL_PRIVACY = '0' ,IT GIVES BACK A RESULT 235673.
with the condition FT_JOURNEY_STREET_CAT.FL_PRIVACY = '0' with the condition FT_JOURNEY_STREET_CAT.FL_PRIVACY = '0', it gives back this error

ORA-01114: IO ERROR WRITING BLOCK TO FILE 203 (BLOCK # 116871)ORA-27063: SKGFOSPO: NUMBER OF BYTES READ/WRITTEN IS INCORRECT Received on Sat Apr 05 2008 - 12:13:16 CDT