I tend to leave out the sid in a datafile name, saves me from
having to rename it, if i'm doing the transportable tablespace
ordeal.
joe
>>> [EMAIL PROTECTED] 07/05/01 12:03PM >>> 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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). |
- DB on NT Sackwitz, Antje
- RE: DB on NT Steven Hovington
- RE: DB on NT Guy Hammond
- RE: DB on NT Mercadante, Thomas F
- RE: DB on NT Mercadante, Thomas F
- RE: DB on NT Peter McLarty
- RE: DB on NT Guy Hammond
- JOE TESTA