DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: 2 GB File limit

  1. #1
    Join Date
    Sep 2000
    Posts
    362
    Hi,
    I read somewhere that there is a 2 GB file limit in case of NT.

    What will happen if i have my datafiles and tablespaces set to autoextend on and the file size reaches 2GB. Will this crash/freeze the database and what should be done in case this happens.

    Please suggest.

    Thanks
    Anurag

  2. #2
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    Do not let the file size exceed 2047 MB. 2048 MB or higher can corrupt the dbf.

  3. #3
    Join Date
    Mar 2001
    Location
    Cologne, Germany
    Posts
    24
    Hi,

    We had severe problems with the filesize on Linux systems. We always used filesize unlimited. When the last extend was too large, the database told us that the tablespace had no room left, so we added a datafile to the tablespace.

    Two times the datafile reached exactly 2 GB, was corrupt and the tablespace was unrepairable lost. Linux had trouble showing the filesize with a ls command. This is definitely no database bug.

    So you should limit the filesize on linux, too.

    Commit;

    6502

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width