Re: we are in deep trouble regarding datafile

In Windows 2000 NTFS the file size is only limited by the volume size. Volume size is limited to 2Terabytes.

As long as he is on an NTFS partiation, no problem going past 4G.

JKL "Frank van Bortel" <fbortel_at_home.nl> wrote in message news:3BC5E8BF.DD2F4FE9_at_home.nl...
> Vishal Lavti wrote:
> >
> > Hi all,
> > we are facing a problem from last one month and we are not able to
> > solve this .
> > Please help us.We are using windows2000,Oracle8 Enterprise Edition
> > Release 8.0.5.0.0 - Production.
> > the whole database is stored on e: and size of e: is 18 GB.the free
> > space on disk is 6.22GB.Now the prolem is with database tc20.
> > there are tow datafile of tc20
> > tc20.dbf 4gb
> > tc2002.dbf 40mb
> > It happens with tc20 that when we log into tc20 it says
> > Oracle not available
> > afetr that gogn to svrmgr we startup database we encounter this
> > problem.
> >
> > ORA-01122: database file 7 failed verification check
> > ORA-01110: data file 7: 'E:\ORADATABASE\DATAFILES\TC20.DBF'
> > ORA-01251: Unknown File Header Version read for file number 7
> >
> > the actual problem is this that there is mismatch in size of datafile
> > in control file and Os file.
> > we are not able to solve this problem.Please help us.
> > thanks
> > Vishal
>
> Call M$ help - you cannot address over 4GB (altho I thought it was 2GB
> for
> Windows) per file. Quite odd that Oracle was allowed to create a file
> that size...
> But then again: MS/DOS V1.01 had a nasty bug: you could create a file
> with a space
> in the name, but you could never get rid of it. Made it up to 6.2...
> --
> Gtrz,
>
> Frank van Bortel
Received on Sat Oct 13 2001 - 23:21:15 CEST