Yes, that is because locally managed tablespaces use a bitmap to keep
track of space. Dictionary tablespaces use FET$ and UET$ tables (free
extents / used extents).

When you use oracle's stored procedure to convert a tablespace, it
amounts to putting the bitmap where it has space, (not at the file
beginning as with a new tablespace), and then using it for new extents /
segments).

All the old segments will still use the dictionary, so until you move
and/or export/import etc. you have a 'hybrid'.



Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546

-----Original Message-----
From: Hudspith Adam
[mailto:oracledba-ezmlmshield-x59809417.[Email address protected]
Sent: Tuesday, January 02, 2007 12:40 PM
To: LazyDBA Discussion
Subject: RE: dictionnary mode to extent_management_local mode.


Hi David,

It is possible to convert dictionary managed tablespaces to locally
manages
ones - but it's a bit of a mess.

You would be far better off MOVING tables and REBUILDING indexes into
new
locally managed tablespaces if you can afford the downtime.

-----Original Message-----
From: David NGUYEN
[mailto:oracledba-ezmlmshield-x12499273.[Email address protected]
Sent: 02 January 2007 16:59
To: LazyDBA Discussion
Subject: dictionnary mode to extent_management_local mode.

hello experts,

HAPPY NEW YEAR 2007 .

i use 8i oracle version and dictionnary_management mode for all
tablespaces in database
could i change it to extent_management_local mode ..? if yes what is
the
query ..? and what do i have to do..?

thanks in advance

david...




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

************************************************************************
****
****
IMPORTANT NOTICE

House of Fraser (Stores) Limited
Registered office: Granite House, 31 Stockwell Street, Glasgow G1 4RZ
Company Number: 10677

If you have received this e-mail in error, please notify the sender and
delete the e-mail and attachments immediately. This e-mail (including
any
attachments) may contain confidential and/or privileged information. If
you
are not the intended recipient, any reliance on, use, disclosure,
dissemination, distribution or copying of the e-mail or attachments is
strictly prohibited.
We have checked for viruses but the content of an attachment may still
contain software viruses, which could damage your computer system. We do
not
accept liability for any damage you sustain as a result of a virus
introduced by this e-mail or attachment and you are advised to use
up-to-date virus checking software. E-mail transmission cannot be
guaranteed
to be secure or error free.
This e-mail is not intended nor should it be taken to create any legal
relations, contractual or otherwise.
To view our latest in-store news click on:
http://www.houseoffraser.co.uk

************************************************************************
****
****


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page