Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: locally managed tablespace & dictionary managed tablespace

Re: locally managed tablespace & dictionary managed tablespace

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: 30 Dec 2002 09:27:12 -0800
Message-ID: <aupvlg060j@drn.newsguy.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US