Re: 2 GB File Limit

Assumption to shatter:

1:1 relationship between Tablespace and Datafile.

this abstraction between physical (operating system) datafile and logical (Oracle Tablespace) was intended to provide flexibility. take advantage of it.

On NT 4.0 - the limit is 16 GB for a datafile. Try it. I know this, as I saw a site's DB puke when it hit this limit. Why don't you just write a routine to fill a datafile, watch it extend, and check the alert log after it dies?
16 GB will take a little while to fill - better have plenty of beer on hand.

Don't you enjoy crashing your dev database? If you haven't crashed the server, you aren't trying hard enough.

Paul

all your $ORACLE_BASE belong to us.

Ted Knijff wrote:
>
> I don't get it. Where is there a 2GB file limit ? On NT3.5 or NT 4.0
> SP 0 ?. I have a 4 GB USR-Tablespace file on my test server at home on
> NT4 SP6.0a and Oracle 8.0.5. Why not just download SP6a ?
>
> Ted
>
> On Fri, 16 Mar 2001 18:58:36 +0000 (UTC), aminocha_at_herold.com ("Anurag
> Minocha") wrote:
>
> >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
> >
Received on Sat Mar 17 2001 - 18:45:26 CST