Oracle 8.0.5 and SunOs 5.6 problem with datafile > 2 GB

From: <kehinde_at_mindspring.com>
Date: Tue, 21 Sep 1999 18:34:58 GMT
Message-ID: <7s8j4h$ok5$1@nnrp1.deja.com>

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 - 13:34:58 CDT