Re: File Systems vs. Raw Devices

In article <2slilh$57a_at_mailhost.interaccess.com>, dzuzga_at_interaccess (David E. Zuzga) wrote:

> Okay, I have a further question about Oracle and raw devices...
> Is there any problem with raw devices over 2Gb in Solaris 2.3 and
> Oracle 7.0.16.4? This is kind of a weird problem, but let me know
> if any of you have experienced the same.
>
> I created a tablespace on a raw device that has a size of about 3.75GB.
> I then loaded data into this tablespace and created an index on the
> table without any errors. Now, when I go to access the data, I get
> errors like:
> ORA-01115: IO error reading block from file 9 (block 1512057)
> ORA-01110: data file 9: '/dev/rdsk/c0t6d0s6'
> ORA-07371: sfrfb: lseek error, unable to seek to requested block
>
> The strange part is that I can access data in the table up to the block
> where it crosses the 2GB boundary. Everything after that is
> unaccessable. The table and index also pass the ANALYZE ... VALIDATE
> STRUCTURE tests.
>
> Any ideas?
>
> Dave Zuzga (dzuzga_at_interaccess.com)

This problem is of the 32-bit univers where you can address 2^^31-1 = 2'147'483'647. You can't have partitions greater than 2GB under SunOS or Solaris other than using a logical volume manager like OnLine DiskSuite ort the like.
But then, why not create a tablespace consiting of a few datafiles under 2GB in length each?

LM

-- 
Leo Mannhart
Planning Office
University of Zurich               phone: ++41 1 257 23 34
Kuenstlergasse 15                    fax: ++41 1 257 22 12
CH-8001 Zurich, Switzerland        eMail: mannhart_at_zuv.unizh.ch