Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: alter table extend
bdbafh_at_gmail.com wrote:
> that smells of Oracle 7.3.
> What version of the database server software are you using?
> Pretty much everything after 7.3 defaults to maxextents unlimited.
>
> -bdbafh
I'd also wonder about the blocksize. I seem to recall the default 2K blocksize limiting extents to 121, requiring rebuilding any object hitting that with larger extents, and contributing to myths about trying to get things into one large initial extent.
Little things like that are why we ask for platform and version information, folks!
jg
-- @home.com is bogus. This showed up in the advertising pane next to google groups: http://addict3d.org/index.php?page=viewarticle&type=security&ID=6143&title=SQL%20Injection%20in%20incredibleindia.orgReceived on Fri Apr 21 2006 - 13:21:09 CDT