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.
Do not let the file size exceed 2047 MB. 2048 MB or higher can corrupt the dbf.
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.