Tablesspaces and Datafiles - Max Sizes?

Hi All,

I'm looking at building a rather large database to hold ocean mapping data, currently in v7.3.4, soon to be in v8.0.5 on a Digital UNIX box. The idea is to keep a LARGE chunk of data from an even larger "off-line" archive sitting on-line in a series of tables within a massive tablespace. Sizes of close to 300-500 GIG on-line have been tossed around.

To date, I've never pushed the size of individual datafiles past 1000M, which of course means 300-500 individual datafiles for that tablespace. Anyone have any comments/thoughts on how large a datafile can *SAFELY* be, and how many datafiles a given tablespace can have, and its relationship to the MAXDATAFILE clause of the CREATE DATABASE command?

Cheers!

James Received on Wed Sep 13 2000 - 12:49:05 CDT