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

Thanks Thiru and Jonathan,

We upgraded to 8.0.5.2.0 and set the largefile switch on (Veritas). Now we can create 4G datafiles. (we have 1.2TB, so reducing the file size wasn't a feasible option.)

The latest is that a procedure that processed 1K rows/min takes 5 mins. Maybe we have to upgrade to 8.0.5.2.1.

Any sugestions?

HKT In article <7s8j4h$ok5$1_at_nnrp1.deja.com>,   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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 30 1999 - 22:47:18 CDT