Re: Oracle 8.0.5 and SunOs 5.6 problem with datafile > 2 GB

Hi there,
It is a limitation on Oracle 8.0.5 and I think got fixed on 8.0.5.1 . However you can Use Raw devices > 2GB on Oracle 8.0.5.0 itself.

It used to be a limitation on Solaris 2.5.1 and earlier..

Hope this helps..

-Thiru

kehinde_at_mindspring.com wrote:

> For the Oracle/Unix Gurus out there --
>
> From ServerManager, I type
>
> SQL> alter tablespace XXXX
> 2 add datafile 'YYYY.dbf'
> 3 size 2048M;
>
> It returns
>
> alter tablespace XXXX
> *
> ERROR at line 1:
> ORA-01119: error in creating database file 'YYYY.dbf'
> ORA-27044: unable to write the header block of file
> SVR4 Error: 27: File too large
> Additional information: 3
>
> Running oerr message utility --
>
> [/u01/app/oracle]oerr ora 27044
> 27044, 00000, "unable to write the header block of file"
> // *Cause: write system call failed, additional information
> indicates which
> // function encountered the error
> // *Action: check errno
> [/u01/app/oracle]
>
> The platform is SunOs 5.6. and the Oracle version is 8.0.5.
>
> $ uname -a
> SunOS BillPlexPrime 5.6 Generic_105181-05 sun4u sparc SUNW,Ultra-
> Enterprise
>
> How do I create a datafile larger than 2GB? Is this a Sun or Oracle
> issue?
>
> HK Thompson
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Sep 21 1999 - 14:34:52 CDT