Re: Locally vs dictionary managed tablespaces

rene.nyffenegger_at_gmx.ch (Rene Nyffenegger) wrote in message news:<Xns90F6E5A57853Dgnuegischgnueg_at_130.133.1.4>...

> 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