Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Initial extent of table
A copy of this was sent to Peter Chan <chanp_at_nortel.ca> (if that email address didn't require changing) On Mon, 01 Jun 1998 08:36:30 -0400, you wrote:
>Is there a maximum on the initial extent size of a table?
>
it can't be larger then the largest datafile in the tablespace the object you are creating resides in.
>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?
>
That would be a really bad idea. See above.
An extent is a contigous collection of blocks within a file. An extent always fits within a datafile and never crosses datafile boundaries. A segement is a collection of extents. Segments may cross datafile boundaries since each extent for a segment may be in a different datafile.
>Thanks a bunch!
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Mon Jun 01 1998 - 00:00:00 CDT