Re: ORA-01200 on RAID 5

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Thu, 08 Apr 1999 16:51:32 +0200
Message-ID: <370CC274.F2083703@vnl.nl>

Mark,

the error means that the OS returns the size (of the datafile), that is less than you actually specified. You're not installing on compressed file systems, are you? Check the attributes of the directory: compress should be OFF for the database directories.

Mark Wagoner wrote:

> We have started using 8.0.5 and have seen a lot of the following
> error:
>
> ORA-01200 Actual filesize xxxxxxx is smaller than correct size
> yyyyyyy blocks.
>
> The error occurs during a CREATE TABLESPACE statement. It has
> happened on both Dell and Compaq servers now, so I have ruled out a
> hardware issue. All three servers are NT 4 with SP3 and nothing
> appears in the event log.
>
> Any ideas?
>
> --
> Mark Wagoner
> To reply, remove no.spam from my e-mail address

--
Frank van Bortel

Technical Consultant Oracle
V&L Informatica BV

Work                                Home
Postbus 545                         Hunzestraat 4
7500 AM Enschede                    7555 WB Hengelo
(31)53.434.1500                     (31)74.242.5046

Received on Thu Apr 08 1999 - 09:51:32 CDT