Re: Extent Management in SYSTEM tablespace

kirtan wrote:

> Hi all,
> I'm using Oracle 9.2i. As far as i know, the SYSTEM tablespace is by
> default created as a locally managed tablespace. Can I change this
> tablespace into a dictionary managed tablespace? Is it possible?
> Also can someone tell me which one, LMT or DMT, is better?

The only good reason for having a dictionary managed SYSTEM tablespace is as a bad example. If you are looking for something to do let me suggest a StatsPack. ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)