From: pagesflames@usa.net (Dusan Bolek) Newsgroups: comp.databases.oracle.server Subject: Re: Locally vs dictionary managed tablespaces Date: 8 Aug 2001 05:46:59 -0700 Organization: http://groups.google.com/ Lines: 19 Message-ID: <1e8276d6.0108080446.383e2fad@posting.google.com> References: NNTP-Posting-Host: 152.158.26.52 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 997274820 20725 127.0.0.1 (8 Aug 2001 12:47:00 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 8 Aug 2001 12:47:00 GMT rene.nyffenegger@gmx.ch (Rene Nyffenegger) wrote in message news:... > What does it mean, the extent information is in the tablespace itself. > Where is it stored in dictionary managed tablespaces? What is the > extent information anyway? I think that dictionary managed tablespaces is pretty self explanatory. Information is stored in dictionary, which is in SYSTEM tablespace. Extent information is info about extents. Extents are parts allocated when database object is too big to fit in allocated space. Initial extent is allocated when you create DB object. Information consists of storage parameters, extents size etc. -- _________________________________________ Dusan Bolek, Ing. Oracle team leader