Re: local vs. dictionary

From: dkrpata1 <dkrpata1_at_cox.net>
Date: Fri, 25 Jan 2002 07:34:38 GMT
Message-ID: <iU748.4263$T23.207448@news2.east.cox.net>

To check to see which tablespaces are locally managed tablespaces, LMT or normal dictionary, try this query:

SELECT TABLESPACE_NAME,EXTENT_MANAGEMENT FROM DBA_TABLESPACES; This will show the tablespace name and if it is DICTIONARY or LOCAL managed.

Dan
www.quest.com

"A Wong" <ajkwong5_at_hotmail.com> wrote in message news:Kd748.1734$jb.231619_at_news2.calgary.shaw.ca...
> how do you tell if your database is a locally managed tablespace or
> dictionary managed? My database was setup automatically by the vendor's
> scripts which I can't seem to find. Also, what would be the best method
in
> trying to dissect the database so I understand how it works and how users
> interact with it?
>
>
Received on Fri Jan 25 2002 - 01:34:38 CST