help tablespace

zichy

unread,

Apr 5, 2008, 1:13:16 PM4/5/08

to

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

DA Morgan

unread,

Apr 5, 2008, 1:33:19 PM4/5/08

to

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
damo...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

zichy

unread,

Apr 5, 2008, 2:57:35 PM4/5/08

to

> damor...@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

Michael Austin

unread,

Apr 5, 2008, 4:08:00 PM4/5/08

to

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 not
match the original number, additional information indicates both these
numbers
Action: check errno

DA Morgan

unread,

Apr 5, 2008, 7:39:40 PM4/5/08

to

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

damo...@x.washington.edu (replace x with u to respond)

Frank van Bortel

unread,

Apr 7, 2008, 3:00:19 PM4/7/08

to

Michael Austin wrote:

>
> ORA-27063: number of bytes read/written is incorrect
> Cause: the number of bytes read/written as returned by aiowait does
> not match the original number, additional information indicates both
> these numbers
> Action: check errno

Compressed filesystem? Virusscanner deleting files?
--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up