Re: 8.5 GB tablespace

On Mon, 4 Mar 2002 07:29:29 +1100, Howard J. Rogers <dba_at_hjrdba.com> wrote:
> Please include error *text* as well as numbers (not everyone has the ability
> to do an 'oerr ora xxxx' to see what the numbers mean).
>
> In this case, I think you are hitting either an O/S limitation in the
> possible size of datafiles, or an internal Oracle error based on the fact
> that, however big the files may be physically, Oracle can only address a
> certain number of blocks (I suspect the latter).
>
> Solution: try creating multiple smaller datafiles. If you want an 8Gb
> tablespace, create it with 4 2Gb datafiles. If you've already got the
> tablespace created, that's just "alter tablespace blah add datafile
> '/x/y/file2.dbf' size 2000m;" as many times as necessary.
>

    Hello     

    I have something like this on my screen     

    ORA-19502: write error on file
    "/opt/oracle/oradata/lbs/DATA.dbf", blockno     32769 (blocksize=16384)
    ORA-27069: skgfdisp: attempt to do I/O beyond     the range of the file

    Additional information: 32769
    Additional information: 64
    Additional information: 32769
    

I dont have problem with large file. I can create file <2GB. System

    Redhat linux 7.1
    Kernel 2.4.17+trustees ACL
    Oracle 8.1.7     

    I dont know what to change on my system to create 8.5 GB tablespace     

    TIA

-- 
  Marcin Jakubowski
  Ambient, 
  www.ambient.com.pl