Re: help tablespace
From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 05 Apr 2008 16:39:40 -0700
Message-ID: <1207438779.918338@bubbleator.drizzle.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
Date: Sat, 05 Apr 2008 16:39:40 -0700
Message-ID: <1207438779.918338@bubbleator.drizzle.com>
zichy wrote:
> 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
Follow up on Michael Austin's suggestion but I am puzzled as to why you would consider running a production database on software in desupport to which no one has applied a single patch of which there have been 7 major ones in the last 8 years. If this database is holding something more than your mother's cookie recipes consider getting to 9.2.0.8 or 10.2.0.2.
-- 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.orgReceived on Sat Apr 05 2008 - 18:39:40 CDT