Re: help tablespace
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Sat, 05 Apr 2008 20:08:00 GMT
Message-ID: <A_QJj.184$CW.2@newssvr11.news.prodigy.net>
>>> 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 the file is a temporary file, then it is also possible that the device has run out of space. This could happen because disk space of temporary files is not necessarily allocated at file creation time.
Action: Restore access to the device or remove unnecessary files to free up space.
Action: check errno Received on Sat Apr 05 2008 - 15:08:00 CDT
Date: Sat, 05 Apr 2008 20:08:00 GMT
Message-ID: <A_QJj.184$CW.2@newssvr11.news.prodigy.net>
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
What is file 203? I do not recall the size limits of files on XP, but it acts as if it 1) runs out of space or 2) exceeds file size limit.
ORA-01114: IO error writing block to file string (block # string) Cause: The device on which the file resides is probably offline. ****************************
If the file is a temporary file, then it is also possible that the device has run out of space. This could happen because disk space of temporary files is not necessarily allocated at file creation time.
Action: Restore access to the device or remove unnecessary files to free up space.
ORA-27063: number of bytes read/written is incorrect Cause: the number of bytes read/written as returned by aiowait does notmatch the original number, additional information indicates both these numbers
Action: check errno Received on Sat Apr 05 2008 - 15:08:00 CDT