Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablesspaces and Datafiles - Max Sizes?
The current limit on a single data file is 2G.
HTH
tED
"James Hanway" <hanwayj_at_XXXmar.dfo-mpo.gc.ca> wrote in message
news:39BFBDF3.3A946C49_at_XXXmar.dfo-mpo.gc.ca...
> 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 - 17:42:14 CDT
![]() |
![]() |