Re: help tablespace

zichy wrote:
> 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
If it is a production system open an SR at metalink. If not repost with complete version information, etc.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org