> which
> parameter I need to set up to
> increase the file size limit?
There isn't one. On NT the filesize is limited by
the type of filesystem (FAT, FAT32, NTFS, etc...).
I suspect the bug in question is bug 711563, and it's
fixed in the latest 7.3.4.x and 8.0.x patchsets. Yet
another reason to be on the latest patchset ;)
See the following metalink docs:
Note: 62427.1 "2Gb or Not 2Gb - File limits in Oracle"
Note: 67421.1 "ALERT: Do NOT use files >= 4Gb on NT in
Oracle8"
Note: 45968.1 "Oracle on NT - Some Facts, Figures and
Limits"
HTH,
- Anita
- lhoska_at_calibresys.com wrote:
> I am running multiple Oracle 7.3-8i databases on NT.
> Is there someone on
> this forum who can answer my question:which
> parameter I need to set up to
> increase the file size limit? I have a feeling
> there may not be one.
> I was told by one of the super-senior Oracle people
> :-) there is an Oracle
> (not NT) bug with Oracle versions below 8i which
> creates problems with
> datafiles above 2G size.
> Thank you.
>
> -----Original Message-----
> Sent: Thursday, May 31, 2001 4:10 PM
> To: Multiple recipients of list ORACLE-L
>
>
> On our old AIX system we had to set a system
> parameter for the file system
> that allowed us to have files bigger than 2 GB. I
> do not know if your
> system has something like that.
>
> -----Original Message-----
> Sent: Thursday, May 31, 2001 2:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> What do you mean by 'the system is not set up'. How
> do you verify that?
> We had problems with datafiles larger then 2 G and
> just turned autoextend
> off on all datafiles.
> I didn't know the system may or may not be set up to
> handle specific file
> size limit. Is it documented?
> Please explain. Thank you.
>
> -----Original Message-----
> Sent: Thursday, May 31, 2001 1:08 PM
> To: Multiple recipients of list ORACLE-L
>
>
> If the system is not setup to allow files bigger
> than 2 GB then the
> datafiles WILL NOT EXTEND and you will get an oracle
> error.
>
> -----Original Message-----
> Sent: Thursday, May 31, 2001 9:31 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I have taken over an Oracle database that is setup
> with autoextend on the
> tablespaces. Can anyone tell me what happens when
> the datafiles extend
> beyond 2G on Unix?
>
> .
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Kevin Lange
> INET: kgel_at_ppoone.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: lhoska_at_calibresys.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Kevin Lange
> INET: kgel_at_ppoone.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: lhoska_at_calibresys.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu May 31 2001 - 18:23:19 CDT
