RE: DB on NT

ALso, what does "1GB" actually mean? That much data, if you dumped it all out into a CSV file? A 1GB tablespace to hold all the data (and how is that tablespace organized)? 1GB being the sum of the sizes of all the datafiles? So, even if there were such a saying, it would be meaningless.

What I like to do, and perhaps this is just me, is to have all the datafiles within a tablespace the same size. So, if I calculated that I needed a 2G tablespace, I might create 4 500M datafiles, and when I needed more I would add more 500M datafiles. I just think this makes things easier to manage, from a physical storage perspective. And contrary to the letter (rather than the spirit) of OFA, I name datafiles:

/<mount point>/<sid>_<tablespace>_<number>.dbf

Anyone else do something like this?

guy

-----Original Message-----
Sent: Thursday, July 05, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L

Perhaps it is confusion with filesize and then it is a whole different ball
game and not only for NT but some older unixes and other OS's as well. and
then we can start the arguments for using raw or not using raw for files

under unix.

Peter

At 10:45 PM 5/07/2001, you wrote:
>Antje
>
>"I know there was a saying - put no database larger than 1 GB on a NT
>machine."
>
>The above is nonsense. I have a database that is 200G on NT. I know
of no
>limit regarding database size on NT.
>
>Tom Mercadante
>Oracle Certified Professional
>
>
>-----Original Message-----
>Sent: Thursday, July 05, 2001 7:02 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi,
>
>Regarding the issue of databases larger than 1GB on NT, could someone
please
>explain this to me, as I was not aware of this 'saying'.
>
>Thanks in advance,
>
>Steven H.
>
>-----Original Message-----
>Antje
>Sent: 05 July 2001 10:51
>To: Multiple recipients of list ORACLE-L
>
>
>Hi,
>I' hav to build up foolowing matrix
>
> DB Size <..
>Operating system
>NT
>Sun Solaris
>AIX
>...
>Has anyone a similar matrix to share?
>Especially I'm interested in the size for NT.
>I know there was a saying - put no database larger than 1 GB on a NT
>machine.
>Is this still true with 8.1.7 or is it stable with larger databases
also?
>
>Regards,
>Antje
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Steven Hovington
> INET: steven.hovington_at_procession.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: Mercadante, Thomas F
> INET: NDATFM_at_labor.state.ny.us
>
>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: Peter McLarty
  INET: peter.mclarty_at_incts.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: Guy Hammond
  INET: guy.hammond_at_avt.co.uk

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