Re: help tablespace

On 5 Apr, 19:33, DA Morgan <damor..._at_psoug.org> wrote:
> 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
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Nascondi testo tra virgolette -
>
> - Mostra testo tra virgolette -

ORACLE 9I 9.2.0.1.0
SO WINDOWS XP Received on Sat Apr 05 2008 - 13:57:35 CDT