We use Oracle 8.0.5 and NT4.0. Our database was corrupted a few days
ago. The corrupted file, usr1cmed.ora, is a datafile in users
tablespace. It had the size 4GB. We also failed to do the backup.

So, we delete the old database and cleaned up the registry file. Then we
tried to recreat a database using the same name as before, the name of
tablespaces are also the same. I tried to create the datafile in the
users tablespace with size 4.0 GB but I failed. I could create a file
with 2 GB. I don't know the reason why I can't create the file with 4GB.
Our hard disk has enough space for it. Even worse, after I created a 2GB
datafile for the user tablespace, I tried to extent the zise to be 4GB,
the file got corrupted again.

Can anybody give me a hand? I truly appreciate it.

Answer:

It is a bug Oracle for NT  8.0.5.0 (fixed in.8.0.5.15.)
If a datafile auto extends beyond the 4 GB Oracle will change size of this
file to a zero.
BWT it is a maximum file size in NT (4096M), but on any case Oracle need to
check it.
You can create 2 and more  datafiles with 2G for 1 tablespace.