Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Locally vs dictionary managed tablespaces
Yes this means the extent information is stored in the tablespace itself. If you're using dictionary managed the information is kept in the FET$ and UET$ base data dictionary tables.
-- HTH. Additions and corrections welcome. Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA "Rene Nyffenegger" <rene.nyffenegger_at_gmx.ch> wrote in message news:Xns90F6E5A57853Dgnuegischgnueg_at_130.133.1.4...Received on Wed Aug 08 2001 - 17:18:18 CDT
> Hi
>
> Because of another thread in this NG, I wanted to find out
> about locally managed tablespaces. The key phrase I found is:
>
> Locally managed tablespaces track all extent information in the tablespace
> itself, using bitmaps, resulting in the following benefits:
> <list of benefits, many starting with improved...>
>
> 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?
>
> Tnx
>
> Rene
>
>
> --
> Recherchen im Schweizerischen Handelsamtsblatt:
> http://www.adp-gmbh.ch/SwissCompanies/Search.php3