Re: 2 GB File Limit

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 16 Mar 2001 20:26:06 +0100
Message-ID: <tb4tjgh5lomgf5@beta-news.demon.nl>

""Anurag Minocha"" <aminocha_at_herold.com> wrote in message news:EBBA6D3A81229C42981E3AEA79BF5A4E111242_at_jshemail.herold.com...
> 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
>
>
> --
> Posted from mr1.ash.ops.us.uu.net [198.5.241.86]
> via Mailgate.ORG Server - http://www.Mailgate.ORG

This are questions with so obvious answers, that it would surprise me if you are incapable to answer them yourself.
I would also recommend you try to answer them yourself, you will benefit more from trying to answer them yourself, compared to use this newsgroup as *first* resort, as you have been doing the past few weeks. IMO, setting tablespaces and datafiles is always a very bad idea, as you will be incapable to exercise control over your database.

Regards,

Sybrand Bakker, Oracle DBA Received on Fri Mar 16 2001 - 13:26:06 CST