Re: Initial extent of table

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 CDT