Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: locally managed tablespace & dictionary managed tablespace
In article <9mPP9.160621$qF3.11566_at_sccrnsc04>, "Jim says...
>
>Don't use locally managed tablespaces.
>Jim
Jim
Can you elucidate please? I found viewpoints like this way back in history when LMT's first came out, but virtually everyone I speak to now uses them. What's your reasoning here?
Pete
>"andi" <andi_at_a.com> wrote in message
>news:auodnb$7d5$1_at_mawar.singnet.com.sg...
>> Hi,
>> newbie question.
>> I've read some books which mentioned about advantages of locally-managed
>> tablespace over dictionary-managed tablespace.
>> My question is, are there advantages of dictionary-managed tablespace over
>> locally-managed tablespace ?
>> or when should we use dictionary-managed tablespace instead of
>> locally-managed tablespace ?
>>
>> TIA,
>> Andi
>>
>>
>>
>
>
HTH. Additions and corrections welcome.
Pete
SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Mon Dec 30 2002 - 11:27:12 CST