Re: Datefile > 1GIG

A copy of this was sent to Mitchell Loren <mloren_at_home.com> (if that email address didn't require changing) On Sat, 21 Aug 1999 18:56:29 GMT, you wrote:

>I am trying to create a tablepace with a datafile > 1GIG by resizing it.
>( ORACLE 7.3.4 with patches applied, AIX 4.3.2,IBM SP-RS6000 )When doing
>so I get the following error:
>
>ERROR at line 1:
>ORA-01237: cannot extend datafile 35
>ORA-01110: data file 35: '/data3/report/inlarge2_1.dbf'
>ORA-09972: sfsfs: unable to resize a file smaller
>IBM AIX RISC System/6000 Error: 27: File too large
>Additional information: 183106
>Additional information: 8192
>
>I have no trouble creating a file of 1 GIG but cannot create or resize a
>datafile > 1 GIG. The datafile was created with maxsize unlimited and
>autoextend on.
>
>Has anyone run into this problem ? Is it an Oracle or AIX limitation.

what does "limit filesize" from the command prompt say? sounds like you have a filesize limit turned on at the OS level.

$ limit filesize
filesize unlimited

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Aug 21 1999 - 14:13:29 CDT