I think it's automatic on Solaris 2.8 but I don't know for sure so I'd rather not rely on it.
I'm going with 2001M and creating about a year's worth of tablespaces/partitions..... 101 datafiles and tablespaces. Just to START. my aching typing fingers! --- Paul Baumgartel <[EMAIL PROTECTED]> wrote: > I believe that the OS filesystem has to be configured for large file > support (on HP-UX, it's a kernel parameter) to allow files > 2 GB. > > I usually just add 1 MB to the file size to allow for the header. > Personally, I'd play it safe and go with however many 2001 MB files > you > need to accommodate your objects. > > > --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > > I'm betting that it's not 64-bit Oracle. See, I am the development > > DBA. > > As an employee, I get to create the scripts, but I don't get to run > > them or even get access as "oracle" to the servers. > > > > In other words, all the grunt work, all the responsibility for > > problems > > (production is managed by a hosting company) but none of the power > to > > make sure it's right. > > > > I love my job. Why? > > > > Rachel > > > > > > __________________________________________________ > Do you Yahoo!? > New DSL Internet Access from SBC & Yahoo! > http://sbc.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Baumgartel > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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). __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
