Re: 2 GB File Limit

We get signal...
;-)

"Loopback Detected" <dest_unreachable_at_yahoo.com> wrote in message news:3AB40519.12B31028_at_yahoo.com...
> 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:50:12 CST