Re: Tbsp created à la old fashion on 9i yet EXTENT_MANAGEMENT='LOCAL'

On 2 Mar 2005 01:41:45 -0800, spendius_at_muchomail.com (Spendius) wrote:

>Hello,
>How come I see all my tablespaces created with explicit
>storage clauses on a 9i DB appear with SYS.TS$.BITMAPPED
>different of 0 (and thus DBA_TABLESPACES.EXTENT_MANAGEMENT
>with the value 'LOCAL') ?
>(besides where does the value of BITMAPPED in SYS.TS$ come
>from ?, I have 32, 256 and 2560)
>
>Thanks.

Locally managed is the default. If you didn't specify dictionary managed, your storage clauses were probably ignored, as they should have been.
Why do you want to stick to dictionary managed? Want to stay busy with boring work?

--
Sybrand Bakker, Senior Oracle DBA