Re: 2 GB File Limit

Don't have 16GB free here. Will try it at the office. Thanks for shattering my illusions.

Ted
On Sun, 18 Mar 2001 00:50:12 GMT, "Mustapha Nuvvercrap" <hashmanKILLSPAM_at_bigpond.net.au> wrote:

>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
>> > >
>
>

EMail: knijff_at_bigfoot.com Received on Sun Mar 18 2001 - 01:11:56 CST