Re: Initial extent of table
Date: 1998/06/03
Message-ID: <01bd8f20$a2ab4260$090610ac_at_aduggasani.aeronomics.com>#1/1
An extent size was limited to 2G in 32 bit Oracle. I am not sure if that got changed in the 64 bit version Oracle RDBMS.
You can not create a table in a tablespace with initial extent size greater than the max file size. By definition, an extent needs to be contigous space in a datafile.
Good luck
Amar Duggasani
Peter Chan <chanp_at_nortel.ca> wrote in article <3572A04E.34EF_at_nortel.ca>...
> Is there a maximum on the initial extent size of a table?
>
> Is it a good idea to make an initial extent of a table to be larger than
> the size of a datafile in a tablespace?
>
> Thanks a bunch!
> --
> ====================================================================
> PETER CHAN, Northern Telecom
> PHONE: (613) 763-9096 FAX: (613) 763-4408 EMAIL: chanp_at_nortel.ca
> ====================================================================
>
Received on Wed Jun 03 1998 - 00:00:00 CEST